Contents Index Query overview SQL queries

ASA SQL User's Guide
  Queries: Selecting Data from a Table
    Query overview

Queries are made up of clauses


You construct SELECT statements from clauses. In the following SELECT syntax, each new line is a separate clause. Only the more common clauses are listed here.

SELECT select-list
FROM table-expression  ]
WHERE search-condition  ]
GROUP BY column-name  ]
HAVING search-condition  ]
ORDER BY { expression | integer }  ]

The clauses in the SELECT statement are as follows:

Most of the clauses are optional, but if they are included then they must appear in the correct order.

For more information about the SELECT statement syntax, see SELECT statement.


Contents Index Query overview SQL queries