SELECT Statement

  • Article

The first clause of the SELECT statement defines which columns to return in the rowset and aliases for those columns. The SELECT statement has the following basic syntax:

SELECT <columns> …

You specify what information to return in the <columns> specification. You must specify at least one column of information to retrieve. You can also specify an alias for a column name.

This section includes the following topic:

FROM Clause

General Query Language Information

ORDER BY Clause

RANK BY Clause

Search Error Messages

Subscription Query Language

WHERE Clause