Search found 4 matches

by jon.charterina@ehu.eus
Tue May 28, 2019 6:45 pm
Forum: PATSTAT Product Line
Topic: Retrieving tables of random sample
Replies: 2
Views: 2000

Re: Retrieving tables of random sample

Dear Martin, Thank you very much for your advice. I had seen the notes you sent me before in the web. I am not an expert as to adapt some of these sentences, in the right way. However, if I am not wrong, I think SELECT TOP * IS not a solution if you want to extract a table that is identical in terms...
by jon.charterina@ehu.eus
Wed May 22, 2019 3:10 pm
Forum: PATSTAT Product Line
Topic: Retrieving tables of random sample
Replies: 2
Views: 2000

Retrieving tables of random sample

Dear Sirs, I need to create a random sample of patens from PATSTAT. Browsing in the net, I have found a command form Microsoft SQL: TABLESAMPLE (xx ROWS) However, it seems it does not work in the editor. Being an unexperienced user of SQL I wonder if I am using it correctly. My query is quite patchy...
by jon.charterina@ehu.eus
Wed May 22, 2019 12:07 pm
Forum: PATSTAT Product Line
Topic: Problems from nested SELECT
Replies: 2
Views: 2419

Re: Problems from nested SELECT

Thank you very much for your help!
I have copy-pasted your sentences.
Best,
JCh
by jon.charterina@ehu.eus
Tue Mar 12, 2019 11:59 am
Forum: PATSTAT Product Line
Topic: Problems from nested SELECT
Replies: 2
Views: 2419

Problems from nested SELECT

Hi, I am new in this trade. I am asking for help regarding the command I put here (below). I want to retrieve a list of patents containing the number of publications, claims, cited patents, cited articles and data from tls201_appln (main table), and tls209_appln_ipc (restriction to IPCs) All the tim...