select 姓名,sum(datediff(n,开始时间,case when 结束时间='' then '2011-08-31 23:59:59' else 结束时间 end))/60 as 总时间,sum(cast(特殊 as int)) as 特殊时间,count(单据编号) as 次数 from logs where b_id like '201108%' group by 姓名
在ms sql里顺利执行, access中不行了
...全文
1237打赏收藏
问个sql查询转到access里的查询语句
access的表结构和ms sql中表一致,但access很少用,不太熟悉函数,请帮忙改写一下 select 姓名,sum(datediff(n,开始时间,case when 结束时间='' then '2011-08-31 23:59:59' else 结束时间 end))/60 as 总时间,sum(cast(特殊 as int)) as 特殊时间,count(单据编号) as 次数 from logs where b_id like '201108%' group by 姓名 在ms sq
select 姓名,sum(datediff(n,开始时间,iif(结束时间='','2011-08-31 23:59:59',结束时间))/60 as 总时间,sum(cast(特殊 as int)) as 特殊时间,count(单据编号) as 次数 from logs where b_id like '201108%' group by 姓名
select 姓名,sum(datediff(n,开始时间,iif(结束时间='','2011-08-31 23:59:59',结束时间))/60 as 总时间,sum(cast(特殊 as int)) as 特殊时间,count(单据编号) as 次数 from logs where b_id like '201108%' group by 姓名