WHERE Clause

Purpose: The WHERE clause filters records based on specific conditions, limiting the results to those that meet the criteria.Syntax:

WHERE condition;

Example:

SELECT * FROM employees WHERE salary > 60000;

Explanation: This retrieves all records from the employees table where the salary exceeds 60,000.