Select from following answers:- LAD() OVER()
- ROW_NUMBER() OVER()
- ORDER BY OFFSET and FETCH NEXT
- DENSE_RANK() OVER()
- All Above
we can use the following logic for pagination task in SQL Server 2012... Especially OFFSET n ROWS is introduced in MSSQL 2012
OFFSET (@PageNo-1)*@RecordsPerPage ROWS
FETCH NEXT @RecordsPerPage ROWS ONLY
Show Correct Answer
Asked In: Many Interviews |
Alert Moderator