| 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; |
Oliver et al. BMC Bioinformatics 2004 5:146 doi:10.1186/1471-2105-5-146 |
|