SQL programs

Data

Name find number of references in papers with references

Description

SQL Program 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

Maximum Rows

Maximum Columns