Results 1 to 3 of 3
  1. #1
    Join Date
    Jul 2012
    Posts
    2

    Unanswered: Print Nth row first in order

    Hi All,

    Greetings...

    I need to put a particular value of column at first in an order...

    Like I have table "MYTABLE" and column "NAME" with values..

    OBAMA
    HILARY
    GANDHI
    BUSH
    PIYUSH
    CLINTON
    HITLER
    JAGUAR

    I want to display "PIYUSH" at position 1 and rest in alphabatical order..

    Please Help..

    Regards,
    Piyush

  2. #2
    Join Date
    Jan 2004
    Location
    Croatia, Europe
    Posts
    4,094
    Provided Answers: 4
    Code:
    order by decode(name, 'PIYUSH', 1), name

  3. #3
    Join Date
    Jul 2012
    Posts
    2
    Thanks a ton Littlefoot..

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •