SELECT Statement

The first clause of the SELECT statement defines which columns to return in the rowset. Following is the basic syntax for the SELECT statement:

SELECT <columns> …

You specify what information to return in the <columns> specification. You must specify at least one column of information to retrieve.

Note  Microsoft SharePoint Portal Server Search (SharePointPSSearch) does not support using column aliases.

This section includes the following topic:

• Specifying Query Columns

Related Topics

FROM Clause

General Query Language Information

ORDER BY Clause

RANK BY Clause

WHERE Clause