UPDATE SMPLT_SUBMITINFO
SET DNREADFLAG=1
WHERE EXISTS
(
SELECT 'X' FROM
(
SELECT DNINDEX FROM SMPLT_SUBMITINFO
WHERE DNGWNO = 1
AND DNREADFLAG = 0
AND ROWNUM>300+1 ORDER BY DNPRIORITY DESC
) B
WHERE B.DNINDEX=SMPLT_SUBMITINFO.DNINDEX )
这样就全了,大家都帮帮忙啊
SET DNREADFLAG=1
WHERE EXISTS
(
SELECT 'X' FROM
(
SELECT DNINDEX FROM SMPLT_SUBMITINFO
WHERE DNGWNO = 1
AND DNREADFLAG = 0
AND ROWNUM>300+1 ORDER BY DNPRIORITY DESC
) B
WHERE B.DNINDEX=SMPLT_SUBMITINFO.DNINDEX )
这样就全了,大家都帮帮忙啊
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货