Re: Show CAS, USD first; the left ordered by currency name

[Harald Fuchs <hari(dot)fuchs(at)gmail(dot)com>]

In article <4A71F9CB(dot)9050805(at)encs(dot)concordia(dot)ca>,
Emi Lu <emilu(at)encs(dot)concordia(dot)ca> writes:

> 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
> ...

Probably the shortest solution is

  SELECT code, description
  FROM currency
  ORDER BY code != 'CAD', code != 'USD', code;

BTW: your data are obsolete.  Andorra has the Euro.