GuillermoParedes
10/29/2018 - 7:13 PM

sql query paginado

WITH CTEResults AS ( SELECT Emp_Codigo, HCL_CODIGO, HCL_APPAT, HCL_APMAT, HCL_NOMBRE, ROW_NUMBER() OVER (ORDER BY HCL_FECHA) AS RowNum FROM SE_HC )

SELECT * FROM CTEResults WHERE RowNum BETWEEN 21 AND 30;

paginadoSql
content_copyfile_download
WITH CTEResults AS
(
    SELECT Emp_Codigo, HCL_CODIGO, HCL_APPAT, HCL_APMAT, HCL_NOMBRE, ROW_NUMBER() OVER (ORDER BY HCL_FECHA) AS RowNum
    FROM SE_HC
)

SELECT * 
FROM CTEResults
WHERE RowNum BETWEEN 21 AND 30;