Use MySQL CASE function to first sort result into 3 sets, then sort them by columns:
SELECT City, Country FROM Customers
ORDER BY (CASE
WHEN Country LIKE 'U%' THEN 1
WHEN Country LIKE 'S%' THEN 2
ELSE 3
END), Country, City;
The output will be:
City Country
Cowes UK
London UK
London UK
Albuquerque USA
Anchorage USA
Boise USA
Butte USA
Elgin USA
Barcelona Spain
Madrid Spain
Sevilla Spain
Bräcke Sweden
Luleå Sweden
Bern Switzerland
Genève Switzerland
Graz Austria
Salzburg Austria
Bruxelles Belgium
Charleroi Belgium
Montréal Canada
Tsawassen Canada
Vancouver Canada
Aachen Germany
Mannheim Germany
Stuttgart Germany
Barquisimeto Venezuela
Caracas Venezuela
No comments:
Post a Comment