Progress
SQL-92
Guide and Reference


SELECT Statement

Selects the specified column values from one or more rows contained in the tables or views specified in the query expression. The selection of rows is restricted by the WHERE clause. The temporary table derived through the clauses of a select statement is called a result table.

SYNTAX

SELECT column_list 
  FROM table_list 
    [ WHERE search_condition ] 
    [ GROUP BY grouping_condition ] 
    [ HAVING search_condition ] 
    [ORDER BY ordering_condition ] 
    [FOR UPDATE update_condition ] 
; 

column_list

See the COLUMN_LIST Clause.

FROM table_list

See the FROM Clause.

WHERE search_condition

See the WHERE Clause.

GROUP BY grouping_condition

See the GROUP BY CLAUSE.

HAVING search_condition

See the HAVING CLAUSE.

ORDER BY ordering_condition

See the ORDER BY Clause .

FOR UPDATE update_condition

See the FOR UPDATE Clause.

AUTHORIZATION

Must have DBA privilege or SELECT permission on all the tables or views referred to in the query_expression.

SQL COMPLIANCE

SQL-92. Progress Extensions: FOR UPDATE clause, ODBC Extended SQL grammar

ENVIRONMENT

Embedded SQL (within DECLARE), interactive SQL, ODBC applications, JDBC applications

RELATED STATEMENTS

"Query Expressions" in "SQL-92 Language Elements", DECLARE CURSOR Statement, OPEN Statement, FETCH Statement, CLOSE Statement


Copyright © 2004 Progress Software Corporation
www.progress.com
Voice: (781) 280-4000
Fax: (781) 280-4095