摘要:
1.使用Row_number() over(order by columnName)函数来作为标示分页(下面的例子都是以last_seen来排序的,要求取顺序为20-30行的数据)SELECTUsername,real_filename,Row_number() over (order by last_seen desc) as rn INTO #tempTable from AllftplogSELECT * FROM #tempTable where rn between 20 and 30;2.使用IDENTITY来设定行号,根据行号来分页SELECT Username,real_fil
阅读全文