Question

我如何改变这一选举标准,以便删除标准?

SELECT COUNT(empid), empid, status, deptid from tableA 
GROUP BY empid, status, deptid HAVING status is null and deptid = 5

Answer 1

What do you want to delete?

简单地记录一下民族解放军的优越地位 Id5

WHERE status is NULL and DeptID = 5

你们是否在寻求超过......

Answer 2

不能工作,也不得工作。

您可以尝试如下,请看看它是否发挥作用。

DELETE 
FROM tableA
WHERE status is null AND deptid=5

Answer 3

DELETE FROM tableA 
WHERE status is null AND deptid = 5

Answer 4

Delete from tableA a, 
(SELECT COUNT(empid) as count, empid, status, deptid from tableA 
    GROUP BY empid, status, deptid HAVING status is null and deptid = 5) as b 
where a.empid = b.empid
and a.status = b.status
and a.deptid = b.deptid
and b.count > 5

你们所期待的东西是什么? 它将删除所有属于该组一部分的记录,并计票;5

否则,你实际上不会从某个集团中删除价值,并且可以使用简单删除;

Delete from tableA 
where status is null 
and deptid = 5

友情链接