Reg Order By

[vamsioracle]

hi



recently i had come across a query, where it included order by. But the order by statement was different. It looked like


select
............... .
............

from
............... .......
where
............... .......
............... .......

order by 5,4,3


what does these number indicate here.

thank you

[debasisdas]

those numbers refers to the ordinal position of the fields refered in the query. an d it always starts from 1.

order by 5,4,3 means

order by 5th field then by 4th filed then by 3rd field.