This week's book giveaway is in the OO, Patterns, UML and Refactoring forum. We're giving away four copies of Refactoring for Software Design Smells: Managing Technical Debt and have Girish Suryanarayana, Ganesh Samarthyam & Tushar Sharma on-line! See this thread for details.
I have a table with columns custname (VARCHAR(20) NOT NULL), orderno (INT NOT NULL). If I use SELECT * FROM table to retrieve data, the data is displayed in the ascending order of custname and then orderno. But I want the data to be displayed in the order of insertion into the table. Will anybody please tell me which query should I use to do this ?