Table having only one column. The column having 5 values those are 'A', 'A','A','B','B'
I want output like this 'B', 'B','B','A','A'.
I got the output by using CASE Statement. Is there any other approach to get the output.
CASE WHEN Column_Name = 'A' THEN 'B'