How to obtain Unique records based on a column value not based on entire row values

Hi,

I have a requirement where I need to obtain unique records based on a column.Unique snap doesn’t work here,as it looks on each unique record instead of a column

for ex: My data looks like this

e_no email country firstname last name
1 abc@gmail.com India A B
2 abc@gmail.com USA A B
3 abc@gmail.com UK A B
4 a@gmail.com India c D
5 b@gmail.com US C D

My output should look like, After removing duplicate email address

e_no email country firstname last name
1 abc@gmail.com India A B
4 a@gmail.com India c D
5 b@gmail.com US C D