Basic COUNTs 4

• Steve Jones - SSC Editor

  SSC Guru

  Points: 737685

  More actions

  February 8, 2018 at 11:20 pm

  #333448

  Comments posted to this topic are about the item Basic COUNTs 4

• manik_anu

  SSCrazy

  Points: 2397

  More actions

  February 9, 2018 at 6:10 am

  #1979225

  nice question... thanks

  Manik
  You cannot get to the top by sitting on your bottom.

• webrunner

  SSC-Dedicated

  Points: 31957

  More actions

  February 9, 2018 at 8:32 am

  #1979249

  Thanks for this question! I recently re-learned this info, and the way I remembered it (I know it's probably a bad mnemonic but it works for me) is: "COUNT (ALL col) does not COUNT ALL"  -meaning it excludes NULLs.

  - webrunner

  -------------------
  A SQL query walks into a bar and sees two tables. He walks up to them and asks, "Can I join you?"
  Ref.: http://tkyte.blogspot.com/2009/02/sql-joke.html

• Stewart "Arturius" Campbell

  SSC Guru

  Points: 72699

  More actions

  February 11, 2018 at 9:36 pm

  #1979378

  Interesting....
  thanks for the question, Steve

  ____________________________________________
  Space, the final frontier? not any more...
  All limits henceforth are self-imposed.
  “libera tute vulgaris ex”

• Make an Impact

  SSChasing Mays

  Points: 652

  More actions

  February 12, 2018 at 3:00 pm

  #1979534

  Interesting question. "The ALL will be applied to all values, with the NULL eliminated" may be incorrect. I tried running the same query without COUNT() and found NULL value in the result set. 
  SELECT
ALL tc.varcharcol
FROM dbo.TheCounts AS tc