当前位置:数据库 > DB2 >>

DB2的分页语句


DB2的分页语句
 
SELECT * FROM     www.zzzyk.com  
2 (    
3 SELECT B.*, ROWNUMBER() OVER() AS RN FROM   
4 (    
5 SELECT * FROM <TABLE_NAME>    
6 ) AS B    
7 )AS A WHERE A.RN BETWEEN <START_NUMBER> AND <END_NUMBER>;
CopyRight © 2022 站长资源库 编程知识问答 zzzyk.com All Rights Reserved
部分文章来自网络,