group by
(case when convert(varchar(5),TD.attendtime,108) <= '13:00' then 0 else 1 end)
TD.attendtime是时间类型,解释一下这句sql的意思,和用途谢谢大家
(case when convert(varchar(5),TD.attendtime,108) <= '13:00' then 0 else 1 end)
TD.attendtime是时间类型,解释一下这句sql的意思,和用途谢谢大家
group by
(case when convert(varchar(5),TD.attendtime,108) <= '13:00' then 0 else 1 end)语句的含义就是把<= '13:00'和> '13:00'的数据group by 起来