SQL programs

Data

Name Search for papers by auth, first page, year

Description

SQL Program SELECT paper_obj.OBJECT_ID, paper_obj.OBJECT_NAME FROM OBJECTS paper_obj, EAV_STRING yearstr, EAV_STRING firstp WHERE lower(paper_obj.OBJECT_NAME) LIKE lower('Severi %') AND paper_obj.OBJECT_CLASS = 42 AND yearstr.OBJECT_ID = paper_obj.OBJECT_ID AND yearstr.value_ = '2009' AND firstp.OBJECT_ID = paper_obj.OBJECT_ID AND yearstr.ATTRIBUTE_ID = 154 AND firstp.ATTRIBUTE_ID = 150 AND firstp.value_ = '3862'

Maximum Rows

Maximum Columns