有一个数据表假设为user,里面有一个name字段,name字段可重复。如何查找 user表中出现次数最多的前10个name?
sql语句:
SELECT
name,
count
(
*
) num
FROM
user
group
by
name
order
by
num
desc
limit
0
,
10