9.17.2 SELECT statement

The SELECT statement contains the following clauses:

• SELECT clause

  Specifies the value based on the type or set function of the object to be searched. Make sure that you specify the SELECT clause.

• FROM clause

  Specifies the range for which a search is applied. Make sure that you specify the FROM clause.

• WHERE clause

  Used for narrowing down the search results. You can omit the WHERE clause.

• GROUP BY clause

  Used for grouping the search results. You can omit the GROUP BY clause.

• HAVING clause

  Used for filtering the grouped search results. You can omit the HAVING clause.

• ORDER BY clause

  Used for the ordered classification of the search results. You can omit the ORDER BY clause.

If the SELECT clause and FROM clause are not specified in the SELECT statement, an exception occurs.

To Page Top