npranj
SSCrazy
Points: 2323
More actions
September 2, 2013 at 4:03 am
#297400
Comparison with respect to performance - pagination options:
1. SQL 2012 has introducted FETCH OFFSET ...
2. SQL 2008 has an option of ROW_NUMBER() using CTE and then pick up specific row numbers.
Viewing 0 posts
You must be logged in to reply to this topic. Login to reply