Mine

select t.terr_id, max(t.start_date) as start_dat

from zz_sr_territory t

where t.start_date <= getDate() and t.end_date>=getDate()
group by t.terr_id;

----------------------------------------------------

select * from zz_sr_territory s where start_date <= getDate() and end_date>=getDate();