Using SQL: SELECT Statement

The SELECT statement has five main clauses to choose from, although,
FROM is the only required clause. Each of the clauses have a vast selection
of options, parameters, etc. The clauses will be listed below, but each of
them will be covered in more detail later in the tutorial.

Here is the format of the SELECT statement:


SELECT [ALL | DISTINCT] column1[,column2]
FROM table1[,table2]
[WHERE "conditions"]
[GROUP BY "column-list"]
[HAVING "conditions]
[ORDER BY "column-list" [ASC | DESC] ]



Example:


SELECT name, age, salary
FROM employee
WHERE age > 50;

The SELECT statement will select all of the values in the name, age,
and salary columns from the employee table whose age is greater than 50.

NOTE: The SELECT statement

back to the top