根据l_number,leave_starttime,leave_endtime相同字段来去重,保留日期最大的条记录
如果日期也相同,则保留id最大的条记录。
select * from t_leave_dd a where
exists(select 1 from t_leave_dd t where t.l_number=a.l_number and t.leave_starttime=a.leave_starttimeand t.leave_endtime=a.leave_endtime and t.leave_date>a.leave_date )
union all
select * from t_leave_dd a where exists
(select 1 from t_leave_dd t where t.l_number=a.l_number and t.leave_starttime=a.leave_starttime
and t.leave_endtime=a.leave_endtime and t.leave_date=a.leave_date and t.id>a.id)