SQL Server WHERE Clause

SQL WHERE Clause


The WHERE clause is used to extract only those records that fulfill a specified criterion.

Syntax


SELECT column_name FROM table_name WHERE column_name operator value


Example:-


SELECT * FROM Persons WHERE Name='Mayank'