All about SQL (Structured Query Language) Common Interview Questions & Answers.
This covers general queries about Microsoft SQL Server, Oracle, Access, MySQL databases.
Thursday, November 5, 2009
What is the difference between a HAVING CLAUSE and a WHERE CLAUSE?
Having Clause is basically used only with the GROUP BY function in a query. WHERE Clause is applied to each row before they are part of the GROUP BY function in a query.
No comments:
Post a Comment