جستجوی صفحه به صفحه در پایگاه داده

select ID, title from software where ID IN(

   select top 10 ID from software where ID IN(

      select top 10 ID from software order by ID)

   order by id desc)

order by id

**********************************************************

select top 10 * from software where id in(

    select top 10 id from software where id IN(

        select top 70 id from software order by id desc)

    order by id asc)

order by id desc