22,210
社区成员
发帖
与我相关
我的任务
分享
UPDATE t SET IsDownload='true',DownloadTime=getdate() OUTPUT DELETED.MOBILE FROM (SELECT * ,ROW_NUMBER()OVER(ORDER BY ID ASC) AS RN FROM tb_CompanyMobiles WHERE UserId=1 AND IsDownload='false' ) AS T WHERE RN<=5
把条件没索引时加上,把语句改为以上方法