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

cy163 · #1 (**permalink**) 08-16-09, 23:51

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

healdem · #2 (**permalink**) 08-17-09, 02:31

possibly, but you cannot rely on that behaviour

Internet Services

Web Development

Digital Marketing

Consumer Tech