關(guān)于行號(hào)問(wèn)題如何用select查詢(xún)解決

字號(hào)： 小 中 大

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