Help to get the records based on latest priority date?

[durgabhavani]

Hi All,

Please find the sample data below and expected output. Help to get the records based on the latest priority date.

Sample Data:

Emp ID	Priority	Date (M/DD/YYYY)
301	High	5/30/2017
301	Medium	6/12/2017
302	Medium	4/20/2017
305	High	2/13/2017
306	High	3/30/2017
306	Low	4/14/2017
306	Medium	5/28/2017
307	High	1/23/2017
307	High	5/18/2017

Expected Output:

Emp ID	Priority	Date (M/DD/YYYY)
301	Medium	6/12/2017
302	Medium	4/20/2017
305	High	2/13/2017
306	Medium	5/28/2017
307	High	5/18/2017

Thanks,

Durga

[durgabhavani]

maild also fine.