SELECT [{LIMIT offsetnumber | TOP number}] [ALL | DISTINCT] {* | column_expression [[AS] column_alias] [,column_expression [[AS] column_alias], ...]}
[INTO [DISK | TEMP] new_table]LIMIT offset numberCreates the result set for the Select statement first and then discards the first number of rows specified by offset and returns the number of remaining rows specified by number. To not discard any of the rows, specify 0 for offset, for example, LIMIT 0 number. To discard the first offset number of rows and return all the remaining rows, specify 0 for number, for example, LIMIT offset0.TOP numberCan be simply a column name (for example, last_name). More complex expressions may include mathematical operations or string manipulation (for example, salary * 1.05). See SQL Expressions for details. column_expression can also include aggregate functions. See Aggregate Functions for details.Copies the result set into new_table. INTO DISK creates the new table in cached memory. INTO TEMP creates a temporary table.
• Separate multiple column expressions with commas (for example, SELECT last_name, first_name, hire_date).
• Column names can be prefixed with the table name or table alias. For example, SELECT emp.last_name or e.last_name, where e is the alias for the table emp.
![]() |
© 2013 Progress Software Corporation and/or its subsidiaries or affiliates. |