How can I write an IF...THEN in an SQL SELECT?

Question

Aryan Kumar · Answer

You can write an if then in an SQL select by using the CASE statement. The
CASE statement allows you to execute different code depending on the value of a condition.
The syntax for writing an if then in an SQL select is as follows:
SQL
SELECT
  column1,
  column2,
  CASE
    WHEN condition1 THEN value1
    WHEN condition2 THEN value2
    ELSE value3
  END AS if_then_column
FROM table_name;
The column1, column2, etc. are the columns that you want to select. The
condition1, condition2, etc. are the conditions that you want to check. The
value1, value2, etc. are the values that you want to return if the condition is met. The
if_then_column is the name of the new column that will be created.
For example, the following code will select the CustomerName column and the
Country column from the Customers table. If the Country column is
USA, then the if_then_column will be set to US Customer. Otherwise, the
if_then_column will be set to Non-US Customer.
SQL
SELECT
  CustomerName,
  Country,
  CASE
    WHEN Country = 'USA' THEN 'US Customer'
    ELSE 'Non-US Customer'
  END AS if_then_column
FROM Customers;

forum

How can I write an IF...THEN in an SQL SELECT?

Revati S Misra

Can you answer this question?

1 Answers

Liked By