Results 1 to 2 of 2
  1. #1
    Join Date
    Aug 2004
    Posts
    6

    Unanswered: Order By Two Columns

    Dear friends,

    My table contains three fields.
    1.EMPID
    2.EMPNAME
    3.DATE
    i want to sort my table based on EMPNAME column in asc order and DATE column in desc order.

    Help me.
    Thanks in advance.
    Siva

  2. #2
    Join Date
    Jun 2004
    Location
    India
    Posts
    15
    Try this:

    select EMPID, EMPNAME, DATE from yourtable
    order by EMPNAME asc, DATE desc


    -Srinivas

Posting Permissions

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