求asp调用数据库的sql语句？
select * from csinfo group by tvname,cslocal order by csid desc;
得到下面的四条数据

csid | tvname | tvfrequence | cslocal | cslevel | csva | cscn |
+------+--------+-------------+----------+---------+------+------+--------+----------+----------+---------+---------+
| 428 | ww| 77.25 | xx | 1 | 1 | 1 |
| 215 | qq | 77.25 | oo | 1 | 1 | 1 |
| 144 | zz | 77.25 | nn | 1 | 1 | 1 |
| 73 | ee| 77.25 | dd | 1 | 1 | 1 |


我想得到“4”这个值，我 select count(csid) from csinfo group by tvname,cslocal order by csid desc; 是不行的，请问我的sql语句怎么写，才能得到4，小弟初学，再线等

[解决办法]
select count(*)不可以?