Previous Topic: SQL ExampleNext Topic: Results

Understanding CA Dataquery › Querying the Database › DQL Example

DQL Example

This is how the query looks in DQL Mode:

 FIND ALL PERSONNEL ROWS
 SORT BY LAST-NAME
 PRINT  LAST-NAME
  FIRST-NAME
  SOCIAL-SECURITY

FIND, SORT and PRINT are DQL keywords. FIND tells which database table to read and SORT arranges the rows alphabetically by name. PRINT specifies which values to display in columns on the report. Other words are available for qualifying the retrieved data, making calculations with it, and controlling how it appears in your report.