select maxcount
 

Hi,

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

Eg:
This is a example query i want the max row count to be printed in the same row. Is it possible?

Re: select maxcount
 

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?

Re: select maxcount
 

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..

Re: select maxcount
 

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;