sql选取第n高的选项
摘要:
select * from sc where score=(select max(score) from sc where score<>(select max(score) from sc))不灵活 select *from (select row_number() over (order by score desc) as idx, * from sc ) as tmptablew... 阅读全文
posted @ 2010-02-18 11:05 无法显示此网页 阅读(245) 评论(0) 推荐(0) 编辑