WHERE clause is used to filter records based on some condition. These conditions make use of logical operators. Some of the illustrated examples are –  SELECT *
FROM employees
WHERE salary > 850000; Returns the records from the employees table where employee salary is greater than 850000.  SELECT *
FROM students
WHERE name LIKE ‘%E’; Returns the records from the students' table where student's name ends with the letter ‘E’.