只需一步,快速开始
1970-1-1 08:00| 发布者: ec| 查看: 2165| 评论: 0
SELECT (SELECT count(*) as dd FROM [121_PinYinIndex ] as a where a.[id]<b.[id]) AS bb, b.[id]FROM [121_PinYinIndex ] AS b;
经常碰到的按成绩排名的问题也可以用同样的方法解决:
SELECT (SELECT count(*)+1 as dd FROM [成绩表] as a where a.[实际成绩]>b.[实际成绩]) AS bb, b.[实际成绩]FROM [成绩表] AS b order by b.[实际成绩] desc
评论
|站长邮箱|小黑屋|手机版|Office中国/Access中国 ( 粤ICP备10043721号-1 )
GMT+8, 2024-5-22 16:28 , Processed in 0.066028 second(s), 16 queries .
Powered by Discuz! X3.3
© 2001-2017 Comsenz Inc.