CTEs as lookup tables
In the past I’ve had to write queries to convert data in a table into user-friendly display text. One way to do this is with CASE expressions. For example, let’s say you have a table with a column being a country code, and you want to add the country name in the final result.
Hasnain says:
Bookmarking this for the future - I wish I’d known about this earlier!
“In the past I’ve had to write queries to convert data in a table into user-friendly display text. One way to do this is with CASE expressions.”
Posted on 2023-01-17T02:18:02+0000