MySQL 统计语句怎么写

Question

签到表 id uid cs create_time cs: 签到次数 每次签到向这个表添加一条数据 怎么统计出签到次数最多的前10个用户??

Answer 1

select uid, sum(cs) as count from table1 group by uid order by count desc limit 10

Answer 2

SELECT MAX(`cs`) FROM 表 group by id ORDER BY MAX(`cs`) DESC LIMIT 10 OFFSET 0

Answer 3

SELECT uid FROM table GROUP BY uid ORDER BY count(id) DESC limit 10