什么是sql查询以查找重复的记录并基于最高计数和降序显示(以降序显示)显示。
例如:
得到计数可以用
select title, count(title) as cnt from kmovies group by title order by cnt desc
结果将是
title cnt
ravi 10
prabhu 9
srinu 6
现在是什么查询才能得到如下结果:
ravi
ravi
ravi
...10 times
prabhu
prabhu..9 times
srinu
srinu...6 times
最佳答案
如果您的RDBMS支持OVER子句...
SELECT
title
FROM
(
select
title, count(*) OVER (PARTITION BY title) as cnt
from
kmovies
) T
ORDER BY
cnt DESC
关于sql - sql查询找到重复的记录,我们在Stack Overflow上找到一个类似的问题:https://stackoverflow.com/questions/6779607/