Limiting the Rows Selected

• We can restrict the rows returned from the query by using the WHERE clause.

Syntax :

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

Example :

SELECT name,job,FROM dept WHERE emp_id = 101;