pagination.sql

/*
 * Exemplo de paginação usado na plataforma
 */

SELECT *
  FROM (SELECT Row_number() OVER (ORDER BY NAME ASC) peta_rn, 
               i.[id], 
               i.[uniqueid], 
               i.[name] 
          FROM [core].[instances] i 
         WHERE (NOT (i.status = @0) AND i.tenantid = @1 )) peta_paged 
WHERE  peta_rn > @2 AND peta_rn <= @3 
-> @0 [Int32] = "4"
-> @1 [Int32] = "4"
-> @2 [Int64] = "0"
-> @3 [Int64] = "10"