SQL: SELECT Statement

SELECT Statement

A  select statement is a combination of two or more clauses.

Syntax:

SELECT *|{[DISTINCT] column [alias],...}

FROM table;

• ·         SELECT - tells the columns to be displayed .
• ·         FROM - tells from which table the columns to be selected.
• ·         DISTINCT - eliminates duplicates
• ·         alias - A different name to a column