User Guide › Preparing for Expert Use › DQL Query

DQL Query

FIND

Starts a query that produces a report, specifying tables to search. Can specify number of rows to find. Can contain clauses that narrow the search and join more than one table.

COUNT

Starts a query that produces a count of rows in a table. Can specify types of rows and join more than one table if WITH and relationship clauses are added.

SET

Creates a report result for each detail row by combining existing columns mathematically.

SORT BY

Sorts rows found. Can specify grouping of rows found (control breaks).

PRINT

Requests columnar report format.

DISPLAY

Requests report format that displays one row per panel (or page). Can specify totaling and other numeric functions.

FIND

Starts a query that produces a report, specifying tables to search. Can specify number of rows to find. Can contain clauses that narrow the search and join more than one table.

COUNT

Starts a query that produces a count of rows in a table. Can specify types of rows and join more than one table if WITH and relationship clauses are added.

SET

Creates a report result for each detail row by combining existing columns mathematically, for example,

SET GROSS = SALES + COMMISSION.

SORT BY

Sorts rows found. Can specify grouping of rows found (control breaks).

PRINT

Requests columnar report format.

DISPLAY

Requests report format that displays one row per panel (or page). Can specify totaling and other numeric functions.