SQL SELECT statement

Database Guide : Database Help : Database windows and dialogs : SQL SELECT statement

An SQL SELECT statement is used to extract specified data from a table or view in the database and return the data in a result table. An SQL SELECT statement is sometimes referred to as an SQL query.

A SELECT statement consists of the following types of clauses:

•SELECT clause

•FROM clause

•An optional WHERE clause

•An optional GROUP BY clause

•An optional HAVING clause

•An optional ORDER BY clause

Last modified date: 01/29/2015