select WorkerID,SUM(CASE WHEN WorkType='按时下班' THEN 1 ELSE 0 END) AS a from CheckWorker where WorkerID=17 GROUP BY WorkerID
这个语句在access中提示"语法错误(操作符丢失)在查询表达式'SUM(CASE WHEN WorkType='按时下班' THEN 1 ELSE 0 END)'中 在sql2000查询分析器中测试是通过的 很急呀,谢谢!
试试 SQL code:
select WorkerID,SUM(CASE [WorkType] WHEN '按时下班' THEN 1 ELSE 0 END) AS a from CheckWorker where WorkerID=17 GROUP BY WorkerID
还有你的ACCESS支持 case 语句吗?
怎么知道access支持不支持case语句? 你的语句我试过了，还是一样的错误 估计是因为aeecss不支持case语句,能用什么代替case语句,实现我要的结果吗? CASE WHEN WorkType='按时下班' THEN 1 ELSE 0 END --------------> iif(WorkType='按时下班',1,0)
