Search found 2 matches

by Angel
Sat May 26, 2018 5:30 pm
Forum: PATSTAT Product Line
Topic: Help with counting backward citation
Replies: 5
Views: 3921

Re: Help with counting backward citation

Hi again and thanks for the replies. I've tried following query: select cited_publication.publn_auth cited_publn_auth ,cited_publication.publn_nr cited_publn_nr ,cited_publication.publn_kind cited_publn_kind ,cited_publication.publn_date cited_publn_date ,cited_publication.appln_id cited_appln_id , ...
by Angel
Wed Apr 18, 2018 3:53 pm
Forum: PATSTAT Product Line
Topic: Help with counting backward citation
Replies: 5
Views: 3921

Help with counting backward citation

Hi everyone, I need a bit of help with a complicated (for me atleast) SQL query. The goal is to find all patents in a given time frame from a selected number of countires, that are citing at least three patents . However these three (or more) cited patens need to belong to a different Section/ Class...