Show CAS, USD first; the left ordered by currency name - Mailing list pgsql-sql

From Emi Lu
Subject Show CAS, USD first; the left ordered by currency name
Date
Msg-id 4A71F9CB.9050805@encs.concordia.ca
Whole thread Raw
Responses Re: Show CAS, USD first; the left ordered by currency name
Re: Show CAS, USD first; the left ordered by currency name
List pgsql-sql
Good morning,

I have a currency table (code, description).

Example values: ADF | Andorran Franc ... ... ANG | NL Antillian Guilder AON | Angolan New Kwanza AUD | Australian
DollarAWG | Aruban Florin BBD | Barbados Dollar USD | US Dollar CAD | Canadian Dollar
 

Is 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




pgsql-sql by date:

Previous
From: Steve Crawford
Date:
Subject: Re: SQL report
Next
From: Andreas Kretschmer
Date:
Subject: Re: Show CAS, USD first; the left ordered by currency name