select '' 序号,fujianserial 附件序号,FUJIANHAOMA 附件号, getname 种类,TicketNoStart 开始票号,TicketNoEnd 结束票号,getnum 数量,inputuser 发出者,outtime 发出时间,GETUSER 领取部门,getdepartment 领取者,beizhu 备注,AttachFileName,AttachFileName1,AttachFileName2,AttachFileName3,AttachFileURL,AttachFileURL1, AttachFileURL2,AttachFileURL3,ID,getTicketNo,billno 单号
from t_fujianlist where fujianserial in (select top 50 fujianserial from t_fujianlist
where fujianserial not in (select top 50 fujianserial from t_fujianlist group by fujianserial order by fujianserial desc) group by fujianserial
order by fujianserial desc ) order by fujianserial
SQL分页读取
最新推荐文章于 2023-11-10 08:22:10 发布