count on count (mysql query)

[shiplu]

Hi,
I have query like this,
mysql> Select count(*) `cnt` From t1 group by name;
+-----+
| cnt |
+-----+
| 120 |
| 320 |
+-----+
2 rows in set (0.01 sec)

But I need a query that will output
+-----+
| cnt |
+-----+
|   2 |
+-----+
1 row in set (0.00 sec)

Got the idea ?

[shiplu]

I resolved it just now.

mysql> select count(*) `cnt` from (Select count(*) From t1 group by name) as P;

+-----+
| cnt |
+-----+
|   2 |
+-----+

1 row in set (0.14 sec)