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

Report message to a moderator

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

Report message to a moderator

Previous Topic: i had a problem with Query
Next Topic: NO DATA FOUND exception
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri Jul 11 04:35:09 CDT 2025
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.