count number of rows returned

[yuva17raj]

hi
i am using the select query with group by, so that i am getting records with more than one column so that i need to calculate the number of rows returned by the query for example

with my select ..group by i get the result as follows
userid count(*)
101 12
105 13
100 10
34 6
but i need to calculate number of rows returned so that my result is 4 kindly specify me with example
regards
yuvaraj

[Dekudude]

Do you want to count the number of rows returned, or do you want to limit it to only 4, so no more show up? If the latter, add "LIMIT 4" after "GROUP BY `` "

[yuva17raj]

hi
thanks for the reply and i have got the result by using this example query
select count(*) from(select distinct(userid ),max(mark) from testtable groupby userid having mark > 90) as single
regards
yuvaraj