SQL programs

Data

Name display papers that have "doi" in the doi field

Description

SQL Program select paper.OBJECT_name,paper.object_id,doi.value_ from objects paper, Eav_string doi where paper.object_class=42 and doi.Attribute_ID=339 and paper.object_id=doi.object_id and doi.value_ like '%doi%' order by paper.OBJECT_name

Maximum Rows

Maximum Columns