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