Search found 1 match
- Wed Sep 24, 2014 2:18 pm
- Forum: PATSTAT Product Line
- Topic: PATSTAT application count sql results
- Replies: 1
- Views: 2052
PATSTAT application count sql results
Dear all, I am running the following SQL on PATSTAT Apr.2014 edition. SELECT date_Part('year', appln_filing_date) as year, count(appln_id), appln_auth FROM tls201_appln WHERE appln_auth in ('US', 'JP', 'EP', 'CN') and date_Part('year', appln_filing_date) > 1970 and date_Part('year', appln_filing_dat...