SQL WHERE Clause

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


SQL WHERE Syntax
SELECT column_name (s) FROM table_name
WHERE column_name operator value


WHERE Clause Example
SELECT * FROM [Address]
WHERE City = 'Chennai'
*This query will listout all data which contains City name as Chennai from Address Table