查询中间几条数据
SELECT add_lst_code,add_lst_name FROM (
SELECT ROW_NUMBER() OVER (ORDER BY add_lst_code) RNO,add_lst_code,add_lst_name FROM tb_lst_type
)WHERE RNO <= 5
ORDER BY add_lst_code ;
SELECT add_lst_code,add_lst_name FROM (
SELECT ROW_NUMBER() OVER (ORDER BY add_lst_code) RNO, add_lst_code,add_lst_name FROM tb_lst_type
)
WHERE RNO BETWEEN 2 AND 4
ORDER BY add_lst_code;
第二种方法
SELECT add_lst_code FROM (
SELECT add_lst_code FROM tb_lst_type
ORDER BY add_lst_code
)
WHERE ROWNUM <= 5
ORDER BY add_lst_code ;
SELECT add_lst_code FROM (
SELECT add_lst_code, ROWNUM RNO FROM (
SELECT add_lst_code FROM tb_lst_type
ORDER BY add_lst_code
)
) WHERE RNO BETWEEN 5 AND 7
ORDER BY add_lst_code;
SELECT add_lst_code,add_lst_name FROM (
SELECT ROW_NUMBER() OVER (ORDER BY add_lst_code) RNO,add_lst_code,add_lst_name FROM tb_lst_type
)WHERE RNO <= 5
ORDER BY add_lst_code ;
SELECT add_lst_code,add_lst_name FROM (
SELECT ROW_NUMBER() OVER (ORDER BY add_lst_code) RNO, add_lst_code,add_lst_name FROM tb_lst_type
)
WHERE RNO BETWEEN 2 AND 4
ORDER BY add_lst_code;
第二种方法
SELECT add_lst_code FROM (
SELECT add_lst_code FROM tb_lst_type
ORDER BY add_lst_code
)
WHERE ROWNUM <= 5
ORDER BY add_lst_code ;
SELECT add_lst_code FROM (
SELECT add_lst_code, ROWNUM RNO FROM (
SELECT add_lst_code FROM tb_lst_type
ORDER BY add_lst_code
)
) WHERE RNO BETWEEN 5 AND 7
ORDER BY add_lst_code;
来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/12961536/viewspace-769492/ ，如需转载，请注明出处，否则将追究法律责任。
请登录后发表评论
登录
全部评论
