errsql: select * from (select row_number() over (order by t.years desc ,forewordID desc ) as row_id, t.forewordID ,t.years,t.title,convert(char(10),t.sDate,126) sDate,img,imgDesc from foreword t where forewordID>0 and t.enable =1 and t.status='P' and t.menuID = 45) x where x.row_id >= 1 and x.row_id <= 20