oracle和sql server分页查询SQL语句

oracle和sql server分页查询SQL语句

数据库  /  管理员 发布于 2021-05-01 14:46:31   14

1.Oracle分页sql语句

SELECT * FROM (SELECT A.*, ROWNUM RN FROM (  select sno,sname,sage,ssex  from tb_student  where 1=1) A  WHERE ROWNUM <'24') WHERE RN >='0'

2.Sql Server 分页sql语句

SELECT sno,sname,sage,ssexFROM ( SELECT ROW_NUMBER() OVER(ORDER BY A.sno ) rownum , A.sno,A.sname,A.sage,A.ssexFROM tb_student  A WHERE 1 = 1 ) T WHERE rownum >= 0 AND rownum < 24