Number of rows returned by GROUP BY

[Anon]

Hello, all!
I need to know the number of rows returned by SELECT statement which contains GROUP BY. How can I do this?

[Anon]

Hi,

Which DB ?

[Anon]

Select statement is like this:

SELECT count(profile_id) FROM categories GROUP BY profile_id;

How can I know, how many rows are returned by this statement? That's the problem. Thanks for attention :-)

[Anon]

I had understood. But depending of your DB there are differents ways achieving this task.

With oracle, sybase, or mssql you could write:

SELECT count('x')
FROM (
SELECT count(profile_id) FROM categories GROUP BY profile_id ) A

Not sure MySQL Support this kind of statement.

[Anon]

Hi,

SELECT count(profile_id) FROM categories GROUP BY profile_id;
With your select, you'll get a column named "count(profile_id)" back, which can be used in php.

SELECT count(profile_id) as numRows FROM categories GROUP BY profile_id;
With this select, you'll get a column named "numRows" back, which can be also used in php.

If you are using mysql, you can count the rows with mysql_numrows($queryresult).

This was tested in mysql/oracle, but should work elsewhere, too.

So long,

Toni

[Anon]

That query will return 1 row... always.

[Anon]

Hi,
your computer is right! It tries to group the id - which is from line to line different - and count it.

To get your rows count, you can use:
select count(*) from database

or
select max(id) from database
which return your maximum id of your database

Toni