What is WHERE statement good for in SQL server script?

Experience Level: Junior
Tags: DatabasesMS SQL ServerQuality Assurance (QA)

Answer

The WHERE statement is used the most often in conjunction with SELECT statement. It applies the filtering condition so only the rows that match the condition defined after WHERE statement are returned in result-set.

The following query will return only customers who ordered more than 3 times.

Query
SELECT * FROM Customers WHERE OrderCount > 3
Related Databases job interview questions

Comments

No Comments Yet.
Be the first to tell us what you think.
MS SQL Server for Testers
MS SQL Server for Testers

Are you learning Databases ? Try our test we designed to help you progress faster.

Test yourself