In this session of , we will learn how to use WHERE clause in SQL. Where clause is one of the more important clauses of three different SQL statements: SELECT, UPDATE & DELETE.
The purpose of the where clause is to identify rows that you wish to include in your result set.
If you leave the where clause out of the SELECT statement, then all the rows of table (or tables) are retrieved.