12 2020 档案

Oracle常用
摘要：分页查询，从第11条查询到第20条并按照sid排序： SELECT * FROM (SELECT a.*, ROWNUM rowm FROM (SELECT * FROM STUDENT ORDER BY SID) a) b WHERE b.rowm <= 20 and b.rowm >10 判断： 阅读全文
posted @ 2020-12-29 11:27 {颜逸} 阅读(101) 评论(0) 推荐(0)