RE: table output order

ORDER BY 1, 2, 3 The SQL Syntax manual! -----Original Message----- From: owner-informix-list@iiug.iiug.org [mailto:owner-informix-list@iiug.iiug.org]On Behalf Of Richard E. Hassler Sent: Friday, December 08, 2000 10:49 AM To: informix-list@iiug.org Subject: table output order I have the latest version of SE (7.?) running on an HP-UX version 10.2. I set up a table of 3 fields one of which is a sequencial number from 1-700. The sequential column is indexed. The data is loaded into the table in ascending order, i.e. 1 2 3 . . . When I do a 'select * from tablename' in SQL or do an escape in the sequential field in a PERFORM screen the rows are displayed in reverse order by sequential number, i.e. 700 699 698 . . . I would like them to list in ascending order, i.e. 1 2 3 . . . Is there any way to do this?