java – 如何对具有不同可能性的单个列的记录求和？

我有一个mysql 查询：

SELECT count(*) as `present_days` 
FROM  tbl_intime_status 
WHERE employee_status = 'Out' and 
      present_status = 'Full Day' and 
      date LIKE '%/"+month2+"/"+year1+"' and 
      employee_id="+ EmpId+

从这个查询我没有.全天礼物.

我有present_status =’半天’& present_status =我的数据库记录中的’全天’.

如何计算’全天”半天’？

最佳答案

如果您希望计数分开,则可以执行此操作

SELECT present_status,count(*) as `present_days` 
FROM  tbl_intime_status 
WHERE employee_status = 'Out' and 
      present_status IN ('Full Day','Half Day')
      date LIKE '%/"+month2+"/"+year1+"' and 
      employee_id="+ EmpId+
GROUP BY present_status

如果你想要两者的总数这样做

SELECT count(*) as `present_days` 
FROM  tbl_intime_status 
WHERE employee_status = 'Out' and 
      present_status IN ('Full Day','Half Day')
      date LIKE '%/"+month2+"/"+year1+"' and 
      employee_id="+ EmpId+

java java

java – 如何对具有不同可能性的单个列的记录求和？

相关文章