SQL programs

Data

Name models between 20050431 and 20060501

Description

SQL Program select datemodelpublic.object_description, model.object_id, model.object_name from objects datemodelpublic, eav_int serialno, objects model where datemodelpublic.object_id=serialno.object_id and datemodelpublic.object_class=127 and datemodelpublic.object_name=model.object_id and datemodelpublic.object_description < '20060501' and datemodelpublic.object_description > '20050431' order by datemodelpublic.object_description

Maximum Rows

Maximum Columns