Group By, Count, and NULLs

Question

Post reply

Group By, Count, and NULLs

jclementz

SSC Eights!

Points: 910
More actions
January 31, 2015 at 5:16 pm

#314201

Comments posted to this topic are about the item Group By, Count, and NULLs
February 2, 2015 at 1:06 am

This was removed by the editor as SPAM

Viewing 15 posts - 1 through 15 (of 18 total)

You must be logged in to reply to this topic. Login to reply

Hany Helmy SSChampion Points: 13921 More actions · Answer 1

Maybe tomorrow QoTD will be:

COUNT(*) AS MyCount

And MyCount value will be 2 in this case (*) for the Null rows

Thanks & Best Regards,
Hany Helmy
SQL Server Database Consultant

Mr. Kapsicum SSCertifiable Points: 6128 More actions · Answer 2

Mr. Kapsicum

SSCertifiable

Points: 6128

February 1, 2015 at 9:48 pm

#1774676

Easy Question.

Raghavendra Mudugal SSChampion Points: 10658 More actions · Answer 3

Hany Helmy (2/1/2015)
Maybe tomorrow QoTD will be:
COUNT(*) AS MyCount
And MyCount value will be 2 in this case (*) for the Null rows

+1

Or, using field "Mychar" in the aggregate function instead of MyId

To Author: Thank you for the post, really good one and I liked the twist of logic happening in my head.

ww; Raghu
--
The first and the hardest SQL statement I have wrote- "select * from customers" - and I was happy and felt smart.

Igor Micev SSC-Dedicated Points: 33110 More actions · Answer 4

Good to know that group by lumps the nulls.

Thanks

Igor Micev,My blog: www.igormicev.com

Koen Verbeeck SSC Guru Points: 259155 More actions · Answer 5

Great question, thanks.

Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP

akljfhnlaflkj SSC Guru Points: 76202 More actions · Answer 6

Thanks for the question. We've had a bunch of these COUNT questions lately.

RLilj33 SSCrazy Points: 2203 More actions · Answer 7

Hany Helmy (2/1/2015)
Maybe tomorrow QoTD will be:
COUNT(*) AS MyCount
And MyCount value will be 2 in this case (*) for the Null rows

Almost got it wrong for *assuming* the count was of the MyChar column. It pays to double-check!

I thought tomorrow's question might be:

COUNT(MyChar) AS MyCount

where MyCount value will also be 2.

ZZartin SSC-Dedicated Points: 30921 More actions · Answer 8

Why are we getting so many count with null questions recently?

Thomas Abraham SSChampion Points: 10761 More actions · Answer 9

Nice question to highlight the differences in ways that NULLs are handled by different operations. Thanks!

[font="Verdana"]Please don't go. The drones need you. They look up to you.[/font]
Connect to me on LinkedIn

RLilj33 SSCrazy Points: 2203 More actions · Answer 10

ZZartin (2/2/2015)
Why are we getting so many count with null questions recently?

1. Good review

2. Helps those less experienced

Ed Wagner SSC Guru Points: 287026 More actions · Answer 11

I appreiate the questions lately. I think it's good to know the different ways that functions work, especially when dealing with NULLs. The basics are always good to know - they're the basics. I learned something from the SOME question a few days ago.

Tally Tables - Performance Personified
String Splitting with True Performance
Best practices on how to ask questions