The SELECT list comprises one or more objects from which to query data. The SELECT list commonly consists of a series of column names separated by commas, or an asterisk operator that represents all columns. More generally, the SELECT list can include one or more expressions, separated by commas. There is no comma after the last column in the list, or if there is only one column in the list.
The general syntax for the SELECT list looks like this:
SELECT expression [, expression ]...
If any table or column name in the list does not conform to the rules for valid identifiers, you must enclose the identifier in double quotes.
The SELECT list expressions can include * (all columns), a list of column names, character strings, column headings, and expressions including arithmetic operators. You can also include aggregate functions.
Selection of all columns from a table
Selection of specific columns from a table
Renamed columns in query results
Character strings in query results
Computed values in the SELECT list
Elimination of duplicate query results
Discuss this page in DocCommentXchange.
|Copyright © 2012, iAnywhere Solutions, Inc. - SQL Anywhere 12.0.1|