SQL WHERE clause is used to filter the database records. The WHERE clause is used to extract only those records that fulfill the specified condition. SQL WHERE clause is used to specify the condition while fetching the data from a single table or by joining the multiple tables.

If the given condition is satisfied, then only it returns the specific value from the table. You should use a WHERE clause to filter the records and fetching the necessary records.

SQL Where Clause Example

SQL WHERE clause is used to specify a condition while retrieving the data from a single table or by joining with multiple tables. If the given condition is met, then only it returns specific value from the table.

The WHERE clause is not only used in the SELECT statement; it is also used in an  UPDATE,  DELETE statement.

#sql #sql where clause #sql where