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
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
解决方案 »
- oracle 10g for solaris x86 下载
- 关于oracle数据库备份与还原问题,高手进!
- Inner join on and left join on
- 请问大家用的是不是正版ORACLE??在电脑城买的10元9I企业版能用于生产扫描吗??
- 请教:安装ORACLE 9i时,刚安装,就出现"加载数据库时出错",怎么办?
- 数据库中碰到奇怪的事情???
- vb.net通过odbc连接oracle低版本(6。0)中,如何通知不同用户
- 请问,那位大哥有oracle的书,电子版
- 在程序中如何取得 存储过程中的输出参数值呀!急用!
- oracle有季度函数吗?我的一个字段是date型号
- 用row_number() over(partition by key1 order by key1 )可以显示组内序号,我还想显示组序号,怎么搞
- 有点难度的SQL,如何查找能做全部检查项目的医院
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
)