Search:     Advanced search
Browse by category:
C/C++   |   Java   |   Oracle/Database   |   SAP   |   ASP .NET   |   Mainframe-DB2   |   Freshers
Home / Oracle / Database / Q: When do you use WHERE clause and when do you use HAVING clause?

Q: When do you use WHERE clause and when do you use HAVING clause?
Print
Email to friend
Add comment
Views: 396
Votes: 1
Comments: 0
A: HAVING clause is used when you want to specify a condition for a group function and it is written after GROUP BY clause. The WHERE clause is used when you want to specify a condition for columns, single row functions except group functions and it is written before GROUP BY clause if it is used.  
 
Others in this Category
document What is Cursor?
document What is the difference between a HAVING CLAUSE and a WHERE CLAUSE?
document Q: Which is more faster - IN or EXISTS?
document What are different normalization forms?
document What are the properties of the Relational tables?
document What is difference between DELETE & TRUNCATE commands?
document What is use of EXCEPT Clause?
document What is Stored Procedure?
document What are the Advantages of using CTE?
document What is a Scheduled Jobs or What is a Scheduled Tasks?
» More articles


RSS
Powered by KBPublisher (Knowledge base software)