Count

• darsha.shashank

  SSC Veteran

  Points: 258

  More actions

  June 1, 2018 at 11:02 am

  #369050

  Hello All,

  I am trying to calculate total DISTINCT COUNT for names.

  Name	ID1	ID2		Visit Flag
  P	1	2		Y
  Q	10	20		Y
  A	30			Y
  B		40		Y
  P	1	2		Y
  Q	1	2	Y
  C	5		Y

  Please help me out on this

  Thanks

• Thom A

  SSC Guru

  Points: 99130

  More actions

  June 1, 2018 at 11:09 am

  #1992669

  What have you tried so far? I suggest having a look at the documentation on COUNT: https://docs.microsoft.com/en-us/sql/t-sql/functions/count-transact-sql?view=sql-server-2017

  Thom~

  Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
  Larnu.uk

• saravanatn

  SSCarpal Tunnel

  Points: 4533

  More actions

  June 1, 2018 at 11:27 am

  #1992674

  darsha.shashank - Friday, June 1, 2018 11:02 AM

  Hello All,

  I am trying to calculate total DISTINCT COUNT for names.

  Name	ID1	ID2		Visit Flag
  P	1	2		Y
  Q	10	20		Y
  A	30			Y
  B		40		Y
  P	1	2		Y
  Q	1	2	Y
  C	5		Y

  Please help me out on this

  Thanks

  I agreed Thorn . Kindly go through the document suggested by Thorn.

  
SELECT COUNT(DISTINCT [name])


  Saravanan

• Thom A

  SSC Guru

  Points: 99130

  More actions

  June 1, 2018 at 11:32 am

  #1992676

  saravanatn - Friday, June 1, 2018 11:27 AM

  I agreed Thorn . Kindly go through the document suggested by Thorn.

  
SELECT COUNT(DISTINCT [name])


  Thom*. I'm not a thorn, thanks. 🙂

  Thom~

  Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
  Larnu.uk