pagination in asp, plays major roll when you want to display page wise results , what if the recordset size is more or huge, in that case the processing of the page will become slow… for that here is the query , which will really help you the following query is mssql query for example if you want employee name whose salaries are 2nd highest and 1oth highest now, step 1 :select *, .. .. ..
