Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase «««23456

HAVING Expand / Collapse
Author
Message
Posted Monday, August 09, 2010 4:41 AM
SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Tuesday, March 22, 2011 5:41 AM
Points: 78, Visits: 48
Hi,
Could not get the having clause ...
can anyonce please explain?
Post #965821
Posted Monday, August 09, 2010 4:47 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Today @ 4:05 PM
Points: 5,793, Visits: 8,002
me_always (8/9/2010)
Hi,
Could not get the having clause ...
can anyonce please explain?
Sure - but such a broad question is too hard to answer (other than with a reference to Books Online).

Have you read the explanation that is given after replying to the question? And have you read the discussion here?

If, after reading all that, you still have a question, I'll be happy to answer - as soon as you tell me what exactly you don't understand.



Hugo Kornelis, SQL Server MVP
Visit my SQL Server blog: http://sqlblog.com/blogs/hugo_kornelis
Post #965827
Posted Monday, August 09, 2010 6:16 AM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Thursday, February 07, 2013 2:54 AM
Points: 317, Visits: 94
Learned something new about HAVING.

Post #965877
Posted Sunday, November 07, 2010 4:18 PM
SSChasing Mays

SSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing Mays

Group: General Forum Members
Last Login: Sunday, November 17, 2013 11:53 AM
Points: 623, Visits: 237
Thanks, i was under the impression that we have to use Having with Group by only and also explanation is clear enough to understand how it works.
Post #1016985
Posted Wednesday, October 09, 2013 1:11 AM


SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: 2 days ago @ 11:50 PM
Points: 1,867, Visits: 2,275
Excellent Question
Great discussion & explanations!



_______________________________________________________________
To get quick answer follow this link:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
Post #1502938
Posted Wednesday, October 09, 2013 1:32 AM
SSC-Addicted

SSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-Addicted

Group: General Forum Members
Last Login: Thursday, April 03, 2014 10:57 PM
Points: 416, Visits: 512
THIS THREAD IS DEFINITELY GIVING A LOT TO LEARN.


SPECIALLY THIS:

SELECT 'One row'
WHERE 1 = 0
HAVING 0 = 0;
Post #1502943
« Prev Topic | Next Topic »

Add to briefcase «««23456

Permissions Expand / Collapse