Progress
Embedded SQL-92
Guide and Reference
SELECT Statement Clauses
The example in the "Elements of a Query" section contains the four clauses of the SELECT statement:
The column names specified in the SELECT clause are referred to as the SELECT list or projection. In this example, the SELECT list includes the last_name and city columns. Based on the selection criteria specified in the WHERE clause, the query returns values into the host variables name_v and city_v. Queries can return multiple rows depending on the selection criteria.
NOTE: If a query can return more than one row, do not use the INTO clause; instead use a cursor operation, described in the "Introduction to Cursors" section.
Copyright © 2004 Progress Software Corporation www.progress.com Voice: (781) 280-4000 Fax: (781) 280-4095 |