I want to use the CASE statement for multiple groupings, such as:
WHEN 'US' THEN 'North America'
WHEN 'US' THEN 'World'
WHEN 'UK' THEN 'EU'
WHEN 'UK' THEN 'World'
END AS cntry_grp
GROUP BY 1
Is there some way to force a fall through after the first match? This would be equivalent to leaving out the 'break;' statements in a JAVA switch statement.
The only way I could think of solving this is by using a table and repeatedly insert the same rows under different namings (US --> North America, US --> World, etc.). Do you know a more elegant solution?