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

You can achieve this with some basic commands.
Cut the 5th and the 6th columns, do a numeric sort and use head to print the first lines.

Regards

cat filename | awk -F"," '{print $5 " " $6}' | sort -nr +1 | head -3

Regards
Naree

Hi can you please explain that what does this command do
sort -nr +1. I am familiar with sort but what is -nr +1

sort -nr +1

-n ---> is number sort
-r ---> is in reverse order
+1 becoz it leave first coloum in output and sort second one ..

Regards

Naree