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
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 |