duplicate minimum date field record

[Vijay_K_N]

I have i/p like this

name,city,date
vijay,bangalore,05-09-1990
vijay,mumbai,06-09-1990
kumar,kolkata,12-11-1991
kumar,chennai,11-11-1991

i want o/p like duplicate minimum date field record 

vijay,bangalore,05-09-1990

kumar,chennai,11-11-1991

[manodwhb · Accepted solution]

sort the data based on name and city and remove duplicate based on name in tuniquerows.

[Vijay_K_N]

i/p data

name,city,date
vijay,bangalore,05-09-1990
vijay,mumbai,06-09-1990
kumar,kolkata,12-11-1991
kumar,chennai,11-11-1991
nanna,kolkata,01-08-2006
nanna,bihar,06-12-2004
nanna,mumbai,05-04-2005
nanna,delhi,09-03-2002

o/p will be like this minimum date fields

name,city,date

kumar,chennai,11-11-1991
nanna,bihar,09-03-2002
vijay,bangalore,05-09-1990

for ur logic wont work here 
name,city,date 
kumar,chennai,11-11-1991
nanna,bihar,06-12-2004
vijay,bangalore,05-09-1990

second row doesnt come minimum date

[manodwhb]

@lli ,as part of sort include date  and sort the required way to get the data.