【单选题】
A SELECT rank( )
as idx , score.* FROM score ;
B B.SELECT row _number( )
over( order by classID ) , score.* FROM score,
C SELECT rank( )
over( partition by (
lassID order by score ) as idx . score.*FROM score;
D SELECT rank( )
over ( order by score partition by ClassID ) as idx score和FROM score
查看更多