OrDB
SQL programs
  Data
find number of references in papers with references
select paper.object_id,paper.object_name, count(bibli.object_id) from objects paper, eav_objects bibli where paper.object_class=42 and bibli.attribute_id=140 and paper.object_id = bibli.object_id group by paper.object_id,paper.object_name order by COUNT(bibli.OBJECT_ID) DESC, paper.object_name
Other categories referring to find number of references in papers with references
Revisions: 3
Last Time: 12/16/2003 11:25:16 AM
Reviewer: Tom Morse - MoldelDB admin
Owner: Tom Morse - MoldelDB admin