Hi, How do i select max count of a table in a single query. Eg: Code: 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?
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?
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..
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;