The name of a field from a table in the FROM clause.Ī constant specifying that the same constant value is to appear in every row of the query results.Īn expression that can be the name of a user-defined function.Īlthough using user-defined functions in the SELECT clause has obvious benefits, you should also consider the following restrictions:
Select_Item specifies an item to be included in the query results. If two or more items have the same name, include the table alias and a period before the item name to prevent columns from being duplicated. Each item you specify with Select_Item generates one column of the query results. You can use DISTINCT only once per SELECT clause.Īlias.
