Why "Where" is used in SQL?

All Questions › Category: SQL › Why "Where" is used in SQL?

CS Electrical And Electronics Staff asked 4 years ago

I need short information.

1 Answers

0 Vote Up Vote Down

CS Electrical And Electronics 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’;