-
Hi,
I am querying a table with country names in it.
I want to display the records in the order they were entered with an exception of one.
For example the records were entered in the order
1. India
2. Australia
3. USA
4. Mexico
5.Brazil
My query should return the names in the following order
India
Australia
Mexico
Brazil
USA
Note that USA is displayed at the end of the result set rather than in the order it was entered and all other records are displayed in the order they were entered.
Please suggest how to do this.
Thanks
Ronnie
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|