Tuesday 28 May 2013

Basic Select Statement or Selecting ALL Columns

Syntax of SELECT Statement


SELECT *|{[DISTINCT] column|expression [alias],....}
FROM table;

> SELECT identifies what columns
> FROM identifies which table

Selecting All Columns

SELECT * 
FROM dept;

Result:




No comments:

Post a Comment