where clause

Whenever you want to retrieve data from your table, there are times that you don’t want to pull all the information. You can retrieve data from the database by using the WHERE clause to filter data based on your criteria.

The WHERE clause in SQL is used to filter out data or to simply select specific data to perform the desired operation.

The WHERE clause can be used in SELECT, UPDATE, and DELETE statement. It is needed to filter what data to select, update, or delete.