Limiting the Rows That Are Selected

Restrict the rows that are returned by using the WHERE clause:

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

FROM   table

[WHERE condition(s)];

The WHERE clause follows the FROM clause.

SELECT employee_id, last_name, job_id, department_id

FROM   employees

WHERE  department_id = 80 ;

EMPLOYEE_ID	LAST_NAME	JOB_ID	DEPARTMENT_ID
1000	PARK	PP1	80
1001	LAKI	PP2	80