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