Home >> SQL >> Where clause in SQL

Where clause in SQL

Where clause used to check condition from a table in database.

It is used in SELECT,UPDATE and DELETE query.

Syntax

SELECT * FROM tablename WHERE condition;

UPDATE tablename  SET column1=value1,column2=value2 WHERE condition;

Post Your Comment

Next Questions
AND Clause
OR Clause
Update query
Delete query
Like clause
IN clause
Order By
Group By
Distinct keyword
Sorting
Between
Having
Union
Union all
Exits
Not Exits
Any
All
Max
Min
Avg
Count
Sum

Copyright ©2022 coderraj.com. All Rights Reserved.