Displaying RowID in Select * (all) Statement
You can do something like
SELECT rowid, a.* FROM table_name aBut I'm not sure that is actually going to help you. Sorting the data on ROWID is not going to be particularly useful since that is just a physical location on disk. It's just as arbitrary as presenting the data unsorted.