Interviews Questions and Answers

0

Like

What is the difference between Having and Where clause?


Posted by: James
On 25 Mar 2012 | Views: 832 | Categories: Database (SQL Server)
Interview Answers(1)

 On 25 Mar 2012 10:54:48 AM
A WHERE clause is used in the select statement to filter the rows as they are retrieved from the database table. HAVING clause is used in the select statement in conjunction with the Group By clause, to filter the query results after they have been grouped.
You can use HAVING clause only when you use Group By clause.

Post your Answers

 

Other lins

.Net Techies
Other lins