select name,count(1) as 次数 from 表 group by name order by count(1) desc
解决方案 »
- 请教高手,怎样修复这种错误?
- 选择的备份文件无效,请确认选择的文件是否是备份文件 ,请问如何解决?
- 〓★★★〓 存储过程分页: 对于非唯一值字段排序 有没有好的解决方法?
- 高分:批量提交大文件的sql脚本到服务端执行,出现性能问题.数据库为MS SQLSERVER
- return日期自动编号。怎么写才效率高? 在线等。。。。。。。。。。。。。。。。。。。。。。。。。。。。。。。。
- 关于默认值的问题 前辈们快来帮忙...
- sql查询指定字段的问题
- 大家好,我是新手,我想问的是“这个sql文件是如何导出的?”
- 各位曾经或正在金蝶做事的兄弟,我要去金蝶,可是另外一家公司也要我,请问
- ADO对UUID进行操作时,遇到00无动作
- 用动态sql的问题
- 昨天提出的生成指定要求的字符只部分解决,再次提出,请高手解决
(select name,count(1) as 次数 from 表 group by name) a
where (select count(1) from (select name,count(1) as 次数 from 表 group by name) b
where b.name=a.name and b.次数<=a.次数) between 1 and 10
from (
select top 10 name,count(1) as 次数
from 表
group by name
order by count(1) desc ) a
from tablename
group by name
order by count(*) desc
(select name,count(1) as 次数 from 表 group by name) a
where (select count(1) from (select name,count(1) as 次数 from 表 group by name) b
where b.name=a.name and b.次数<=a.次数) between 1 and 10
order by a.次数 desc
from (
select top 10 name,count(1) as 次数
from 表
group by name
order by count(1) desc ) a
from (
select top 10 name,count(1) as 次数
from 表
group by name
order by count(1) desc ) a
order by a.次数 desc