order by COUNT(x) in rank

Question

Viewing 4 posts - 1 through 4 (of 4 total)

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

Sean Lange SSC Guru Points: 286609 More actions · Answer 1

That is ordering by the count of rows. Not sure why 9 was chosen. It could just as easily be count(*).

--edit totally misread this post the first time. 😀

_______________________________________________________________

Need help? Help us help you.

Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.

Ron McCullough SSC Guru Points: 63877 More actions · Answer 2

To illustrate the differences try this code

USE Northwind

GO

SELECT COUNT(4) AS 'Count by col number' FROM dbo.Audit -- counts nulls

SELECT COUNT(Item) AS 'count specific col' FROM dbo.Audit --counts only non null values

SELECT COUNT(*) AS 'Count *' FROM dbo.Audit

Results:

Count by col number

-------------------

21

count specific col

------------------

9

Warning: Null value is eliminated by an aggregate or other SET operation.

Count *

-----------

21

If everything seems to be going well, you have obviously overlooked something.

Ron

Please help us, help you -before posting a question please read[/url]
Before posting a performance problem please read[/url]

Jonas Bergström SSC-Addicted Points: 489 More actions · Answer 3

Thought so. It doesn't seem to change the result if I elaborate with changing the '9' to a '1', '0' or '77777' (or '*'). 🙂