Question

sql语句 min （case where ........) 取最小但是不等于0

select a.name,a.deptname,min(case when CONVERT(varchar(10), CHECKTIME, 108)<'11:30:00' then CONVERT(varchar(10), CHECKTIME, 108) else '' end )开始时间 ,max(case when CONVERT(varchar(10), CHECKTIME, 108)>'11:45:00' then CONVERT(varchar(10), CHECKTIME, 108) else '' end )结束时间 , convert(varchar(10),a.CHECKTIME,120) as 设计需求from kqxx as a where a.name='陈廷'group by a.name,a.deptname,convert(varchar(10),a.CHECKTIME,120)

Answer 1

IFNULL(字段，0)空可以这样做。