
Databases contains huge amounts of data and you don’t need to get all the data all the times. Sometimes you only need a specific set of data. Where clause in SQL helps you filter data. It helps you get only the records that you are interested in.
Syntax of Where Clause –
SELECT column1, column2
FROM table_name
WHERE condition
Let’s say that you want to find all the cities information from India. To select only the records from India, you write WHERE CountryCode = ‘IND’
SELECT
Name,
CountryCode,
District,
Population
FROM city
WHERE CountryCode = 'IND';

In this example we used the equality operator but SQL provides many operators that you can use to filter data.

Suppose you want to find all the cities from India whose population is greater than or equal to 1 Million.
SELECT
Name,
CountryCode,
District,
Population
FROM city
WHERE CountryCode = 'IND' AND
Population >= 1000000
