这句SQL SERVER如何转换成ORACLE?
DELETE RULE FROM RULE R
INNER JOIN (
SELECT DEVICETYPEID, ATTACKTYPE, LOCATIONLINK, MAX(CNTRULE) AS MAXRULE
FROM RULE
GROUP BY DEVICETYPEID, ATTACKTYPE, LOCATIONLINK
) MX
ON R.DEVICETYPEID = MX.DEVICETYPEID AND R.ATTACKTYPE = MX.ATTACKTYPE
AND R.LOCATIONLINK = MX.LOCATIONLINK
AND R.CNTRULE < MX.MAXRULE
[解决办法]
DELETE FROM RULE R
where
exists
(select 1
from
(
SELECT DEVICETYPEID, ATTACKTYPE, LOCATIONLINK, MAX(CNTRULE) AS MAXRULE
FROM RULE
GROUP BY DEVICETYPEID, ATTACKTYPE, LOCATIONLINK
) MX
where R.DEVICETYPEID = MX.DEVICETYPEID AND R.ATTACKTYPE = MX.ATTACKTYPE
AND R.LOCATIONLINK = MX.LOCATIONLINK
AND R.CNTRULE < MX.MAXRULE
)
