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: 2009-07-30 19:51:39
Message-ID: 4A71F9CB.9050805@encs.concordia.ca
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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 Dollar
AWG | 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

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Andreas Kretschmer 2009-07-30 20:05:29 Re: Show CAS, USD first; the left ordered by currency name
Previous Message Steve Crawford 2009-07-30 16:41:56 Re: SQL report