MySQL Lists: mysql: Re: Counting distinct rows

List:	General Discussion	« Previous Message Next 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 rows	emoticon	29 Mar
• Re: Counting distinct rows	Paul DuBois	29 Mar
• Re: Counting distinct rows	Gary Huntress	29 Mar
• Re: Counting distinct rows	Thalis A. Kalfigopoulos	29 Mar