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...

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...

Thank you very much for your help!
I have copy-pasted your sentences.
Best,
JCh

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...