[RESOLVED] Help ordering this table

[designxperts]

I have a MySql table like this:

Age | Salary | Interview_score

20 | 1000 | 10
25 | 800 | 5
52 | 2500 | 9
.
.
.

I want to order like this: by the older and the least salary and the highest interview score. All together, i don't wan't to sort by age then by salary then by interview score..

What's the correct way to do this???

Thanks

[laserlight]

I want to order like this: by the older and the least salary and the highest interview score. All together, i don't wan't to sort by age then by salary then by interview score..

That is not possible, unless you devise a formula by which one can compare them "all together".

[designxperts]

okay, thanks very much

[Piranha]

In your example, what order would you like to order the results?

In the table below, how would you like to order the results?

Age | Salary | Interview_score

20 | 1000 | 10
25 | 800 | 5
52 | 2500 | 9
67 | 1800 | 10
50 | 2000 | 6
40 | 1500 | 10
15 | 200 | 10