How to test for equality

You can use an equal sign (=) to select rows for which a specified column contains a specified value.

To select only the rows where the department number is A00, use WHERE DEPT = 'A00' in your SELECT statement:

SELECT FIRSTNME, LASTNAME
  FROM EMP
  WHERE DEPT = 'A00';

This query retrieves the first and last name of each employee in department A00.