Assuming I have data like:
rowid_xfef,city,postal,address,name
1,c1,p1,a1,n1
2,c1,p1,a1,n1
3,c2,p2,a2,n2
4,c3,p3,a3,n3
5,c3,p3,a3,n3
6,c3,p3,a3,n3
I should match city,postal,address,and name and the record with lowest rowid should be printed.
Output should be:
1,c1,p1,a1,n1
3,c2,p2,a2,n2
4,c3,p3,a3,n3
Please do the needful.