oracle和sql server分页查询SQL语句

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,ssex
FROM ( 
SELECT ROW_NUMBER() OVER(ORDER BY A.sno ) rownum , A.sno,A.sname,A.sage,A.ssex
FROM tb_student  A 
WHERE 1 = 1 
) T 
WHERE rownum >= 0 AND rownum < 24