UltraLite Embedded SQL User's Guide
Data Access Using Embedded SQL
Fetching data in embedded SQL is done using the SELECT statement. There are two cases:
The SELECT statement returns at most one row.
The SELECT statement may return multiple rows.
Fetching one row
Fetching multiple rows