Reg Order By

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • vamsioracle
    New Member
    • Jun 2007
    • 151

    Reg Order By

    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
    Recognized Expert Expert
    • Dec 2006
    • 8119

    #2
    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.

    Comment

    Working...