Skip to main content

Table 7 Table 7

From: Tools for loading MEDLINE into a local relational database

SELECT

mc.medline_ta, count(mc.pmid) as num_of_publications

FROM

medline_citation mc

 

JOIN medline_mesh_heading msh ON

 

mc.pmid = msh.pmid

 

JOIN mesh_descriptor md ON

 

md.descriptor_name = msh.descriptor_name

 

JOIN mesh_desc_tree_number mdtn ON

 

md.descriptor_ui = mdtn.descriptor_ui

WHERE

mdtn.tree_number LIKE 'C04.557.337%'

GROUP BY

mc.medline_ta

ORDER BY

count(mc.pmid) desc

FETCH

first 10 rows only;