www.7150.net > 期中考试 五位

期中考试 五位

select * from ( select row_number() over(order by 总成绩 DESC) as 名次,姓名,语言设计,高代,数学分析,总成绩 from 成绩表 ) as e1 where e1.名次>5 或者 select * from ( select row_number() over (order by (语言设计+高代+数学分析) DESC...

网站地图

All rights reserved Powered by www.7150.net

copyright ©right 2010-2021。
www.7150.net内容来自网络,如有侵犯请联系客服。zhit325@qq.com