Change return value of selected SELECT statement

You can change the value of a selected column with the help of conditions. In select statement, case-when-statement takes  if-statement’s place.

CASE WHEN
condition_statement
THEN if_value ELSE else_value END AS column_name

Read More »

Advertisements