Getting the number of rows.

[altendew]

How could I get mysql to just print the number of rows for this query, because this is currently return hundreds of rows. I just want one row.

I want to know how many duplicate first names there is.

SELECT COUNT(*) as total FROM members WHERE first!='' GROUP BY first HAVING total>1

 

[r937]

select count(*) as dupe_firsts
  from (
       SELECT first
            , COUNT(*) as total 
         FROM members 
        WHERE first!='' 
       GROUP 
           BY first 
       HAVING total > 1
       ) as dupes

r937.com | rudy.ca

 

[altendew]

TY =)!