Results 1 to 2 of 2
  1. #1
    Join Date
    Apr 2007
    Posts
    130

    Unanswered: How to read out records in an descent order from a table with using ORDER BY clause

    Hi ALL,

    I have a table looking like,
    Code:
    AccuntNo   char
    Amount      float
    When populating records into the table, records are inserted in descending order of Amount column.

    I wonder whether all records can be read out in descending order with a SQL statement without using 'ORDER BY Amount DESC' clause?


    Thanks

  2. #2
    Join Date
    Nov 2004
    Location
    out on a limb
    Posts
    13,692
    Provided Answers: 59
    possibly, but you cannot rely on that behaviour
    I'd rather be riding on the Tiger 800 or the Norton

Posting Permissions

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