List:General Discussion« Previous MessageNext Message »
From:Paul DuBois Date:September 11 2000 5:46pm
Subject:Re: Counting the result of GROUP BY
View as plain text  
At 1:40 PM -0400 09-11-2000, Lee Nelson wrote:
>Hi Everyone,
>
>   I've been developing an application around MySQL for the
>past few months, and so far it's been a joy to use.
>
>   However, I am having some difficulty constructing a query,
>and hoped that you folks might be able to help.
>
>   I am using a web form to construct a query on the database.
>I wish to show the users how many hits they will get, without
>actually pulling all the data across the link and counting it
>(there are several hundred thousand rows).
>
>   For most cases:
>
>     SELECT count(*) FROM data where (user_criteria)
>
>   works perfectly.  However, one of the query items is
>"unique EINs". for which I would normally construct the
>query as:
>
>     SELECT ein, d1, d2, d4, etc from data
>       where (user_criteria) group by ein;
>
>   But of course if I try to say
>
>     SELECT count(*) from data
>       where (user_criteria) group by ein;
>
>   I just get a large number of counts, instead of a
>single count.
>
>   Is there any way to count the results of a SELECT
>query that includes a GROUP BY clause?


This doesn't do what you want?

SELECT COUNT(*), ein from data where (user_criteria) group by ein;

That gives you a count of each ein value in the result set,
one row per value.

-- 
Paul DuBois, paul@stripped
Thread
Counting the result of GROUP BYLee Nelson11 Sep
  • Re: Counting the result of GROUP BYPaul DuBois11 Sep
Re: Counting the result of GROUP BYLee Nelson11 Sep
  • RE: Counting the result of GROUP BYJeff Brewer11 Sep