this is query and result
SELECT t1.VEND_NUM, t1.CITY_NM, t1.TERR_CD, t1.CNTRY_CD, t1.EFF_DT
FROM VEND_ADDR t1 where vend_num='0003012370';
VEND_NUM CITY_NM TERR_CD CNTRY_CD EFF_DT
1 0003012370 Shelburne ON CA 11/10/2016
2 0003012370 Toronto ON CA 3/7/2013
3 0003012370 Shelburne ON CA 6/17/2016
4 0003012370 Toronto ON CA 5/31/2013
5 0003012370 MelancthonON CA 4/17/2018
6 0003012370 MelancthonON CA 11/6/2018
I want to pick up vendor which has most effective date. I want max (eff_date). Kindly help me this
i want this result only
VEND_NUM CITY_NM TERR_CD CNTRY_CD EFF_DT
6 0003012370 MelancthonON CA 11/6/2018