Why "Where" is used in SQL?

All Questions › Category: SQL › Why "Where" is used in SQL?
0 Vote Up Vote Down
Chetan Shidling Staff asked 4 years ago

I need short information.

1 Answers
0 Vote Up Vote Down
Chetan Shidling Staff answered 4 years ago

The “where” is used to find or filter a particular record, suppose if you want to know people who are living in India and there is a lot of customer detail in the database, then you can filter and find the people or customers who are living in India by using where.
 
SELECT * FROM Customers
WHERE Country=‘India’;