<a href="http://g.adspeed.net/ad.php?do=clk&zid=15220&wd=468&ht=60&pair=as" target="_blank"><img style="border:0px;" src="http://g.adspeed.net/ad.php?do=img&zid=15220&wd=468&ht=60&pair=as" alt="i" width="468" height="60"/></a>
Log in
::
Register
::
Not logged in
Home
Tags
Articles
Editorials
Stairways
Forums
Scripts
Videos
Blogs
QotD
Books
Ask SSC
SQL Jobs
Training
Authors
About us
Contact us
Newsletters
Write for us
<a href="http://g.adspeed.net/ad.php?do=clk&zid=15491&wd=120&ht=300&pair=as" target="_top"><img style="border:0px;" src="http://g.adspeed.net/ad.php?do=img&zid=15491&wd=120&ht=300&pair=as" alt="i" width="120" height="300"/></a>
Recent Posts
Recent Posts
Popular Topics
Popular Topics
Home
Search
Members
Calendar
Who's On
Home
»
Article Discussions
»
Article Discussions by Author
»
Discuss content posted by Stewart Campbell
»
Count Distinct
17 posts, Page 1 of 2
1
2
»»
Count Distinct
Rate Topic
Display Mode
Topic Options
Author
Message
Stewart "Arturius" Campbell
Stewart "Arturius" Campbell
Posted Thursday, January 20, 2011 10:37 PM
Hall of Fame
Group: General Forum Members
Last Login: 2 days ago @ 8:31 AM
Points: 3,129,
Visits: 4,312
Comments posted to this topic are about the item
Count Distinct
____________________________________________
Space, the final frontier? not any more...
All limits henceforth are self-imposed.
“libera tute vulgaris ex”
Post #1051332
Koen Verbeeck
Koen Verbeeck
Posted Friday, January 21, 2011 12:35 AM
SSCrazy Eights
Group: General Forum Members
Last Login: Yesterday @ 2:11 AM
Points: 9,378,
Visits: 6,473
Nice question, but a hard one.
I spent quite some time looking at the query to find some hidden error.
But apparently there wasn't any
How to post forum questions.
Need an answer? No, you need a question.
What’s the deal with Excel & SSIS?
Member of
LinkedIn
. My blog at
LessThanDot
.
MCSA SQL Server 2012 - MCSE Business Intelligence
Post #1051362
Carlo Romagnano
Carlo Romagnano
Posted Friday, January 21, 2011 1:13 AM
SSCommitted
Group: General Forum Members
Last Login: Yesterday @ 12:56 AM
Points: 1,972,
Visits: 1,822
I get it right because of excluding the wrong choices.
Post #1051369
sharath.chalamgari
sharath.chalamgari
Posted Friday, January 21, 2011 2:10 AM
Ten Centuries
Group: General Forum Members
Last Login: Monday, September 17, 2012 7:30 AM
Points: 1,038,
Visits: 679
Nice Question,needs little bit time to go through the Query
Post #1051382
Mayank Parmar
Mayank Parmar
Posted Friday, January 21, 2011 2:39 AM
Say Hey Kid
Group: General Forum Members
Last Login: Wednesday, September 21, 2011 4:03 AM
Points: 713,
Visits: 100
I was sure that "we can Aggregate by columns not included in the SELECT", but I wasn't aware of that use of DISTINCT in Aggregate function, so I had to experiment the same on my own database.
Great Question, really learned something new.
Regards,
--------------------------------------------------------------------------------
Mayank Parmar
Software Engineer
Clarion Technologies
SEI CMMI Level 3 Company
8th Floor, 803, GNFC info Tower,
SG Highway, Ahmedabad - 380 054,
Gujarat, India.
www.clariontechnologies.co.in
Email: mayank.parmar@clariontechnologies.co.in
MSN : mayank.parmar@clariontechnologies.co.in
Mobile: +91 9727748789
--------------------------------------------------------------------------------
Post #1051394
cengland0
cengland0
Posted Friday, January 21, 2011 3:10 AM
Ten Centuries
Group: General Forum Members
Last Login: Thursday, January 24, 2013 9:59 PM
Points: 1,354,
Visits: 1,299
Carlo Romagnano (1/21/2011)
I get it right because of excluding the wrong choices.
Exactly how I did it too.
Post #1051402
rollec2k5
rollec2k5
Posted Friday, January 21, 2011 4:34 AM
SSC-Enthusiastic
Group: General Forum Members
Last Login: Monday, December 17, 2012 2:20 PM
Points: 153,
Visits: 70
I was not aware about, that you can use Columns in a having Clause without having the Column in the SELCET.
However, a nice one.
Greetings
R2d2
Post #1051431
Daniel Bowlin
Daniel Bowlin
Posted Friday, January 21, 2011 7:20 AM
SSCrazy
Group: General Forum Members
Last Login: Wednesday, May 22, 2013 1:10 PM
Points: 2,673,
Visits: 2,418
I have never thought of using count and count distinct in a having clause the way you do. Brilliant. Thanks.
Post #1051518
John Hanrahan
John Hanrahan
Posted Friday, January 21, 2011 8:23 AM
Old Hand
Group: General Forum Members
Last Login: Yesterday @ 11:01 AM
Points: 335,
Visits: 609
I tested this. It doesn't seem to work correctly everytime. But I had never thought of using distinct in a having clause, so nice.
Post #1051580
john.arnott
john.arnott
Posted Friday, January 21, 2011 9:30 AM
UDP Broadcaster
Group: General Forum Members
Last Login: Wednesday, April 17, 2013 10:57 PM
Points: 1,491,
Visits: 3,008
rollec2k5 (1/21/2011)
I was not aware about, that you can use Columns in a having Clause without having the Column in the SELCET.
Not exactly.... The HAVING clause can use
aggregates
like COUNT(), MAX(), SUM() and so on which themselves refer to other columns, but it may not directly refer to a column not in the GROUP BY clause which in turn can only use columns or non-aggregate expressions in the SELECT.
Post #1051634
« Prev Topic
|
Next Topic »
17 posts, Page 1 of 2
1
2
»»
Permissions
You
cannot
post new topics.
You
cannot
post topic replies.
You
cannot
post new polls.
You
cannot
post replies to polls.
You
cannot
edit your own topics.
You
cannot
delete your own topics.
You
cannot
edit other topics.
You
cannot
delete other topics.
You
cannot
edit your own posts.
You
cannot
edit other posts.
You
cannot
delete your own posts.
You
cannot
delete other posts.
You
cannot
post events.
You
cannot
edit your own events.
You
cannot
edit other events.
You
cannot
delete your own events.
You
cannot
delete other events.
You
cannot
send private messages.
You
cannot
send emails.
You
may
read topics.
You
cannot
rate topics.
You
cannot
vote within polls.
You
cannot
upload attachments.
You
may
download attachments.
You
cannot
post HTML code.
You
cannot
edit HTML code.
You
cannot
post IFCode.
You
cannot
post JavaScript.
You
cannot
post EmotIcons.
You
cannot
post or upload images.
Copyright © 2002-2013 Simple Talk Publishing. All Rights Reserved.
Privacy Policy.
Terms of Use.
Report Abuse.
