Search found 1 match

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