摘要:
现有一数据表test,结构如下 studentnamecoursenamemarkaa80ab60ac30ba40bb50bc58ca60cb70cc88da90db70dc881 查出每门功课的前一名(并列名次问题) select * from ( select *,ROW_NUMBER() over(partition by coursename order by mark desc) ranks from test_a ) a where a.ranks=1 partition by :分区;按coursename分区,依据mark排序 即可得到每门课程的... 阅读全文