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: Mon Nov 04 12:38:10 CST 2024