Skip to main content

Table 4 Table 4

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
WHERE msh.descriptor_name = 'Leukemia'
GROUP BY mc.medline_ta
ORDER BY count(mc.pmid) desc
FETCH first 10 rows only;