i have the below select * , ,ROW_NUMBER() OVER
(ORDER BY NAME ASC) AS ROWID
from (select top 10 * ,ROW_NUMBER() OVER
(ORDER BY NAME ASC) AS ROWID from (select top (30)
- ,ROW_NUMBER() OVER
(ORDER BY NAME ASC) AS ROWID from EMPLOYEE order by NAME )
as T1 order by T1.NAME DESC) as T2 ORDER BY NAME ASC
on next click how do i getthe next 10 records??