where

SELECT "column_name"
FROM "table_name"
WHERE "condition"

this will show the results as we specify in where clause
like a particular name, or employess of particular age

it will be like

select name from employee
where age=21;

it will show name of all employees of age 21