Distinct Count

• yrstruly

  Hall of Fame

  Points: 3475

  More actions

  November 19, 2021 at 7:40 am

  #3954736

  I am using the following code for distinct count, seem to give me the same number for count and distinct count. Please assist?

  Attached is the file i imported into sql server.

  Attachments:

  You must be logged in to view attached files.

• ktflash

  Default port

  Points: 1400

  More actions

  November 19, 2021 at 8:28 am

  #3954742

  Did you forget to add the code your talking about by chance?

  I want to be the very best
  Like no one ever was

  https://www.sqlservercentral.com/articles/forum-etiquette-how-to-post-datacode-on-a-forum-to-get-the-best-help

• yrstruly

  Hall of Fame

  Points: 3475

  More actions

  November 19, 2021 at 9:41 am

  #3954769

  USE SKUSS

  SELECT DISTINCT COUNT (NAME) FROM [dbo].

  ---

  USE SKUSS

  SELECT COUNT (*) FROM [dbo].

  ---

• ktflash

  Default port

  Points: 1400

  More actions

  November 19, 2021 at 9:50 am

  #3954771

  is this what ur looking for?

  SELECT COUNT (DISTINCT  NAME) 
  FROM [dbo]

  I want to be the very best
  Like no one ever was

  https://www.sqlservercentral.com/articles/forum-etiquette-how-to-post-datacode-on-a-forum-to-get-the-best-help