SQL分页笔记

  select * from
  (
  select *, ROW_NUMBER() OVER(ORDER BY id  DESC) AS rownum from dbo.fc_newhouse
  )as t
  where t.rownum>@startId and t.rownum<@endId