The SELECT statement lets you filter the results of a query to return only those records that meet specific criteria. For example, if you want to access all database records for employees in department 3, you use the following query:
SELECT * FROM employees WHERE DeptID=3
You can combine multiple conditions using the WHERE clause. For example, the following example uses two conditions:
SELECT * FROM employees WHERE DeptID=3 AND Title='Engineer'