iam getting the result like this,
1,BBBB,Arun
1,BBBB,Ashwin
1,CCCC,Vishwa
2,BBBB,Sam
2,DDDD,John
2,DDDD,Jain
But i want the same values in second column to be together, also the first column should be in order. Here the issue iam facing is that always when i sort the (2,BBBB,Sam) is not coming together with the other BBBB values. But when i sort it and achieve this condition, the other condition that the first column should be in order will break.