select maxcount

divinequran's Avatar, Join Date: Oct 2008
Contributor
Hi,

How do i select max count of a table in a single query.

Eg:
Code:
select type, count(*) as cc, maxcount from t1 group by type;
This is a example query i want the max row count to be printed in the same row. Is it possible?

Last edited by divinequran; 15Oct2009 at 08:54..
0
nimesh's Avatar, Join Date: Apr 2009
Invasive contributor
what do you want in the max row count?

Do you want the rowcount of the recordset returned after the group by?

can you give an example?
0
divinequran's Avatar, Join Date: Oct 2008
Contributor
I have a table with a categories like emp1, emp2, emp3 e.t.c.

I want select the the max count of the category emp1 that is total now of rows of emp1. with where group=tempemp

where i will use where clause..
0
nimesh's Avatar, Join Date: Apr 2009
Invasive contributor
what you want is just the count.
There is no such things as max count

count is just the count of records
max is the maximum value of all the values in a particular column for a table

If you are still referring to your original query, you need to modify it like this.
select type, count(*) as cc from t1 group by type;