Hello,
I'm a student and trying to get some data about the EU patents applications for my master thesis. I want to create a dataset where the columns are the years '2016', '2017' and '2018'. And the rows are the NUTs2 regions, not specified to a country, but for the entire Europe. Can someone help me query? I keep getting errors if I try to create the NUTs2 rows.
Great thanks in advance!
NUTs2 regions
-
- Posts: 425
- Joined: Thu Feb 22, 2007 5:33 pm
- Contact:
Re: NUTs2 regions
Can you post your SQL that gives errors ?
Assuming that your years are the year of filing or priority, you should look into CASE statements which is SQL's way of handling if/then logic.
See this forum note:
sql-queries-to-create-simple-applicant- ... able-10588
Assuming that your years are the year of filing or priority, you should look into CASE statements which is SQL's way of handling if/then logic.
See this forum note:
sql-queries-to-create-simple-applicant- ... able-10588
PATSTAT Support Team
EPO - Vienna
patstat @ epo.org
EPO - Vienna
patstat @ epo.org