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; |