+7When using the Data Profile function on the Person.Person table in the AdventureWorks2014 database I see strange results for the highest and lowest occurence in the LastName field: Diaz is the highest and Billstrom is the lowest. In reality Abbas is the lowest when sorting by LastName ASC where count(*) == 1
I am not entirely sure that 'Highest occurence’ is clear to everyone that is not a natvie speaker: you could also assume this should be the highest sorted value.
Best answer by JTreadwell
Hi
SELECT [LastName], Count([LastName])
FROM [MDW].[Person]
GROUP BY [LastName]
ORDER BY Count([LastName]) DESCIn my version of AdventureWorks, the Person table results in Diaz occurring the most at 211 times.
If you reverse the Order By ASC, I get Barlow, then Billstrom preceding 687 other names that only occur once. Beyond the count, I don’t believe there is any additional sorting happening, so the 687 single occurrences may appear in a different order.
Using this logic, it seems to be working as expected.
+5Hi
SELECT [LastName], Count([LastName])
FROM [MDW].[Person]
GROUP BY [LastName]
ORDER BY Count([LastName]) DESCIn my version of AdventureWorks, the Person table results in Diaz occurring the most at 211 times.
If you reverse the Order By ASC, I get Barlow, then Billstrom preceding 687 other names that only occur once. Beyond the count, I don’t believe there is any additional sorting happening, so the 687 single occurrences may appear in a different order.
Using this logic, it seems to be working as expected.
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
