A WHERE clause in SQL is a data manipulation language statement.
WHERE clauses are not mandatory clauses of SQL DML statements. But it can be used to limit the number of rows affected by a SQL DML statement or returned by a query.
Actually. it filters the records. It returns only those queries which fulfill the specific conditions.
WHERE clause is used in SELECT, UPDATE, DELETE statement etc.
Let’s see the syntax for sql where:
SELECT column1, column 2, ... column n
FROM table_name
WHERE [conditions] WHERE clause uses some conditional selection
| = | equal |
| > | greater than |
| < | less than |
| >= | greater than or equal |
| <= | less than or equal |
| < > | not equal to |
Leave a Reply