06 noiembrie 2012

Sql Server: limit query


SELECT * FROM (
  SELECT *, ROW_NUMBER() OVER (ORDER BY CompanyId) as row FROM Company
 ) a WHERE a.row > M and a.row <= N

-> intai ia primele (N-M) rezultate, dupa care le sorteaza dupa CompanyId