UltraLite User's Guide
The Embedded SQL Interface
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
Optimizing query operation