Why "Where" is used in SQL?


Warning: Trying to access array offset on false in /home3/indiakep/public_html/wp-content/plugins/dw-question-answer/inc/Template.php on line 8
All QuestionsCategory: SQLWhy "Where" is used in SQL?
Chetan Shidling Staff asked 6 years ago

I need short information.

1 Answers
Chetan Shidling Staff answered 6 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’;