delete from table1 where z4 & z5 & z6 in (select z4 & z4 & z6 form table1 where count(z4 & z5 & z6) > 1) and z1 not in (select max(z1) from table1) and z8 not in (select min(z8) from table1)
delete from table1 where id in (select id form table1 group by z4 & z5 & z6 ) and z1 not in (select max(z1) from table1) and z8 not in (select min(z8) from table1)
where z4 & z5 & z6 in (select z4 & z4 & z6 form table1 where count(z4 & z5 & z6) > 1)
and z1 not in (select max(z1) from table1)
and z8 not in (select min(z8) from table1)
用of123 的方法总是提示: “where 子句中不能有合计函数”. 不知何故?
where id in (select id form table1 group by z4 & z5 & z6 )
and z1 not in (select max(z1) from table1)
and z8 not in (select min(z8) from table1)