Progress
Embedded SQL-92
Guide and Reference
Queries Returning a Single Row
The simplest queries are those that return a single row. When you know that a query is to return a single row, use the INTO clause to receive the result of the query.
EXAMPLEThe following example shows a query against the customer table to retrieve the columns last_name, city, and state:
NOTE: If you use SELECT with an INTO clause in a query that returns multiple rows, the operation returns an error message.
Copyright © 2004 Progress Software Corporation www.progress.com Voice: (781) 280-4000 Fax: (781) 280-4095 |