Skip site navigation (1)
Skip section navigation (2)
Peripheral Links
Header And Logo
|
Site Navigation
Show CAS, USD first; the left ordered by currency name
- From: Emi Lu <emilu(at)encs(dot)concordia(dot)ca>
- To: pgsql-sql(at)postgresql(dot)org
- Subject: Show CAS, USD first; the left ordered by currency name
- Date: Thu, 30 Jul 2009 15:51:39 -0400
- Message-id: <4A71F9CB.9050805@encs.concordia.ca> <text/plain>
Good morning, I have a currency table (code, description). Example values: ADF | Andorran Franc ... ... ANG | NL Antillian Guilder AON | Angolan New Kwanza AUD | Australian Dollar AWG | Aruban Florin BBD | Barbados Dollar USD | US Dollar CAD | Canadian DollarIs there a way I can query to display USD AND CAD first, while other rows are ordered by Code.
For example, CAS | Canadian Dollar USD | US Dollar ADF | Andorran Franc ... Thanks a lot! -- Lu Ying
- Follow-Ups:
- Re: Show CAS, USD first; the left ordered by currency name
- From: Harald Fuchs
- Re: Show CAS, USD first; the left ordered by currency name
- From: sergey kapustin
- Re: Show CAS, USD first; the left ordered by currency name
- From: Andreas Kretschmer
- Re: Show CAS, USD first; the left ordered by currency name
- Prev by Date: Re: SQL report
- Next by Date: Re: Show CAS, USD first; the left ordered by currency name
- Previous by thread: SELECT max(time) group by problem
- Next by thread: Re: Show CAS, USD first; the left ordered by currency name
- Indexes: