Home » SQL & PL/SQL » SQL & PL/SQL » Difference between where and having clause (9i,xp)
Difference between where and having clause [message #305280] Mon, 10 March 2008 05:30 Go to next message
vinayhauk
Messages: 1
Registered: March 2008
Junior Member
Hello everyone,

I have a basic doubt in oracle.
Can anyone let me know why we have two different clauses where and having, since where provides the same functionality as having.


Thanks in advance
Regards,
Vinay
Re: Difference between where and having clause [message #305290 is a reply to message #305280] Mon, 10 March 2008 05:45 Go to previous message
ebrian
Messages: 2794
Registered: April 2006
Senior Member
The docs tell all (well almost all most of the time) WHERE and HAVING
Previous Topic: i had a problem with Query
Next Topic: NO DATA FOUND exception
Goto Forum:
  


Current Time: Fri Dec 09 15:17:37 CST 2016

Total time taken to generate the page: 0.32391 seconds