Monday, April 18, 2016

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

Featured Post

Will the data from Oracle Database be lost after formatting the system in which it is installed?

So Someone asked me a question,  Will the data from Oracle Database be lost after formatting the system in which it is installed? Since the ...

Popular Posts