List:General Discussion« Previous MessageNext Message »
From:Paul DuBois Date:March 29 2001 12:22am
Subject:Re: Counting distinct rows
View as plain text  
At 8:32 AM +0800 3/29/01, <emoticon@stripped> wrote:
>Hi, I am trying to count all the distinct id numbers in a column but I
>just can't figure it out... What would be the appropriate select statement
>for this, thanks,

SELECT COUNT(DISTINCT id) FROM tbl_name

-- 
Paul DuBois, paul@stripped
Thread
Counting distinct rowsemoticon29 Mar
  • Re: Counting distinct rowsPaul DuBois29 Mar
  • Re: Counting distinct rowsGary Huntress29 Mar
  • Re: Counting distinct rowsThalis A. Kalfigopoulos29 Mar