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.