mysql - 从 MySQL 表中获取在某个日期或之前添加并在某个日期或之后删除的计数

Question

我对SQL很陌生，我知道的不多

TABLE employee_table 包含以下列

`pkId` INT(10),
`name` VARCHAR(60),
`pfStatus` TINYINT(3),
`is_active` TINYINT(3),
`addedDate` DATE,
`deletedDate` DATE

并且有一个具有给定值的条目

pkId = 1, name = abhips, pfStatus = 0, is_active = 1, addedDate = 2012-08-08, deletedDate = 2012-08-18

-

SELECT COUNT(*) FROM employee_table WHERE pfStatus = 0 AND addedDate >= '2012-07-07' AND deletedDate <= '2012-08-09';

我想获取在特定日期或之前注册并在特定日期或之后删除且 pfStatus = 0 的员工数量。

但我得到的计数是 0 而不是 1，请帮我解决这个查询，要使这个查询正确，需要进行哪些更改？

Answer 1

你的 <=和 >=是错误的方法。

I want to get the number of employees who are registered on or before a particular date and deleted on or after a particular date and pfStatus = 0.

试试这个:

SELECT COUNT(*)
FROM employee_table
WHERE pfStatus = 0
AND addedDate <= '2012-07-07'
AND deletedDate >= '2012-08-09';