關(guān)于行號問題如何用select查詢解決

字號： 小 中 大

SELECT (
    SELECT count(*) as dd
    FROM [121_PinYinIndex ] as a where a.[id]    FROM [121_PinYinIndex ] AS b;
    經(jīng)常碰到的按成績排名的問題也可以用同樣的方法解決：
    SELECT (
    SELECT count(*)+1 as dd
    FROM [成績表] as a where a.[實(shí)際成績]>b.[實(shí)際成績]) AS bb, b.[實(shí)際成績]
    FROM [成績表] AS b order by b.[實(shí)際成績] desc