【SAP HANA 13】SQL 分页（示例）

分页 

SELECT * FROM (   
 SELECT A.*, ROW_NUMBER() OVER(ORDER BY A.START_TIME DESC) RN 
 FROM (  
       	SELECT T.START_TIME FROM WIP.SFC T
		
   ) A   ORDER BY A.START_TIME DESC 
)  
WHERE RN BETWEEN 0 AND 30 

分页总数的统计方式

--Total 
SELECT TOP 1 A2.INDEX_COUNT TOTAL_RECORDS FROM (
   SELECT ROW_NUMBER() OVER(ORDER BY A1.START_TIME DESC) INDEX_COUNT  
   FROM (   
       	SELECT T.START_TIME FROM WIP.SFC T 
   ) A1  
) A2 
ORDER BY A2.INDEX_COUNT DESC