Re: Count number of patent applications per company
Posted: Mon Dec 18, 2017 10:17 am
It seems that the SQL parser has a problem with this code, but it is correct (at least it runs in MSSQL).
I suggest to export the results and make the totals in excel. That will be much easier then trying to find a solution for the final total row.
I suggest to export the results and make the totals in excel. That will be much easier then trying to find a solution for the final total row.
Code: Select all
SELECT docdb_family_id, nb_citing_docdb_fam
FROM tls206_person
join tls207_pers_appln on tls206_person.person_id = tls207_pers_appln.person_id
join tls211_pat_publn on tls207_pers_appln.appln_id = tls211_pat_publn.appln_id
join tls201_appln on tls201_appln.appln_id = tls207_pers_appln.appln_id
where psn_name like 'NEOGEN CORPORATION%'
and publn_first_grant = 1 and (year(publn_date) between 2011 and 2014)
group by docdb_family_id, nb_citing_docdb_fam