sum of distinct records

• bull2000

  SSC Eights!

  Points: 841

  More actions

  January 13, 2005 at 9:15 am

  #60380

  the data (simplied) look like this:

  Name             date

  AAA                1/1/2005

  AAA                 1/1/2005

  BBB                  1/1/2005

  CCC                  1/1/2005

  BBB                   1/2/2005

  BBB                    1/2/2005

  I want to see how many unique users in a day. the result should be like

  3                      1/1/2005

  1                      1/2/2005

  is it possible to achieve that without using cursor?

  thanks a lot!!!

   

   

• Osoba

  SSCommitted

  Points: 1964

  More actions

  January 13, 2005 at 9:22 am

  #537317

  Maybe try something like this:

  select count(Name),date from(select distinct Name,date from testing)A group by date

   

  hope that helps.

• Ste_P

  SSCarpal Tunnel

  Points: 4430

  More actions

  January 13, 2005 at 9:26 am

  #537318

  Simplified a touch:-

  select COUNT(DISTINCT(Name)) FROM

  

  Have fun

  Steve

  We need men who can dream of things that never were.

• Jonathan Stokes

  SSCrazy Eights

  Points: 9861

  More actions

  January 13, 2005 at 10:48 am

  #537338

  As per Steve's answer.

  Easiest way:

  select count(distinct(name)), date

  from testing

  group by date

   

  ---

  ------------------------------
  The Users are always right - when I'm not wrong!