Row selection with SQL statements

You can use SQL statements to select rows from the database to display on your report.

Selecting rows with SQL statements
Selecting rows limits, or creates a subset of, the data in a table. You select rows by creating a row condition.
Selecting rows that have no data
You can select rows that have no data in a column. The columns that contain no data are considered to be null, meaning their values are unknown.
Selecting rows by using specific character values
You can use character values to select the rows you want to view. Make sure that you enclose the data with single quotation marks.
Selecting rows by using conditions
You can specify a condition when you select rows.
Selecting rows using opposite conditions
You specify the opposite of any condition by typing NOT before the entire condition.
Selection symbols to narrow row selection
To select rows using selection symbols for character or graphic data, use the LIKE keyword in a WHERE clause, and the underscore and percent sign as selection symbols.
Narrowing row selection using multiple row conditions
You can create multiple row conditions, and use the AND, OR, or IN keywords to connect the conditions.
Eliminating duplicate rows
Use the DISTINCT keyword to eliminate duplicate rows from a report.

Parent topic: Viewing the data in the database using SQL statements