...

Database Managment - Sql

Back to Course

Lesson Description


Lession - #1295 SQL Where Clause


The SQL WHERE clause is utilized to indicate a condition while bringing the information from a solitary table or by getting together with different tables. In the event that the given condition is fulfilled, just it returns a particular worth from the table. You ought to utilize the WHERE condition to channel the records and bringing just the important records.

The WHERE condition isn't just utilized in the SELECT articulation, however it is likewise utilized in the UPDATE, DELETE explanation, and so on.,

Syntax for Where Clause




SELECT column1, column2, columnN 
FROM table_name
WHERE [condition]




Note:

Database name should be present in database.

Example:



Online compiler