#Windowed

Windowed functions can only appear in the SELECT or ORDER BY clauses

尝试做分页处理selectrow_numberover(orderbyidasc)asrownum,*fromtable whererownum>=(@page*@pagesize-@pagesize)andrownum<=(@page*pagesize)  Gettingth...