Search found 4 matches
- Tue May 28, 2019 6:45 pm
- Forum: PATSTAT Product Line
- Topic: Retrieving tables of random sample
- Replies: 2
- Views: 4131
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...
- Wed May 22, 2019 3:10 pm
- Forum: PATSTAT Product Line
- Topic: Retrieving tables of random sample
- Replies: 2
- Views: 4131
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...
- Wed May 22, 2019 12:07 pm
- Forum: PATSTAT Product Line
- Topic: Problems from nested SELECT
- Replies: 2
- Views: 6521
Re: Problems from nested SELECT
Thank you very much for your help!
I have copy-pasted your sentences.
Best,
JCh
I have copy-pasted your sentences.
Best,
JCh
- Tue Mar 12, 2019 11:59 am
- Forum: PATSTAT Product Line
- Topic: Problems from nested SELECT
- Replies: 2
- Views: 6521
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...