select IFNULL(min(t.calendar_date),#{WORKING_DATE}) from work_calendar t where t.workday_status='0' and t.calendar_date > #{WORKING_DATE}
oracle nvl mysql ifnull
最新推荐文章于 2024-06-02 23:16:50 发布
select IFNULL(min(t.calendar_date),#{WORKING_DATE}) from work_calendar t where t.workday_status='0' and t.calendar_date > #{WORKING_DATE}