Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
sort the data based on name and city and remove duplicate based on name in tuniquerows.
sort the data based on name and city and remove duplicate based on name in tuniquerows.
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
@lli ,as part of sort include date and sort the required way to get the data.