maxcount in a row

[divinequran]

Hi,

 

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

 

Eg:

select type, count(*) as cc, [color=red]maxcount[/color] 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?

 

[corbin]

If you're trying to do what I think, this should work:

 

 

SELECT type, COUNT(type) as cc FROM t1 GROUP BY type ORDER BY t1 DESC LIMIT 1;