Filter
Top Products
[Figure: Converting data from numeric type to character string type]
6.7 Using CASE Expression to Manipulate Data
The CASE expression is used to change the value of a results column depending on the column value, arrange
fetched columns in a sequence based on priority level, and split data to cases to specify an appropriate value to each
case.
Examples of using the CASE expression are as follows.
Example 1:
The number of services used for each user is obtained from history table HISTORYTBL.
Example 2:
According to the number of points, the users and points indicated by a symbol (PLATINUM, GOLD, or
SILVER) are obtained from point table POINTTBL.
119