need top 3 numbers
Hi Every one
I have a text file which is having a might be 100,000 record but i only need a maximum top 3 numbers and its phone number .
please see below the samle file
usa,asasas,ssss,asasasasas,9005451,10000,ikiikkk
uk,asasas,ssss,asasasasas,9005452,110000,ikiikkk
uae,asasas,ssss,asasasasas,9005453,20000,ikiikkk
china,asasas,ssss,asasasasas,9005454,10,ikiikkk
kuwait,asasas,ssss,asasasasas,9005455,100,ikiikkk
qatar,asasas,ssss,asasasasas,9005456,5000000,ikiikkk
bahrain,asasas,ssss,asasasasas,9005457,80,ikiikkk
I need the top three maximum charge vaue which is filed number 6.
it should give me the top 3 results like this.
9005456,5000000
9005452,110000
9005453,20000
PLEASE GIVE ME ANY COMMAND OR UNIX SHELL SCRIPT WHICH CAN HELP ME OUT TO CALCULATE THE TOP 3 NUMBERS OR EVEN I CAN APPLY THIS WITH 100 NUMBERS.
Regards