Sql When Case

[Solved] Sql When Case | Fortran - Code Explorer | yomemimo.com
Question : SQL CASE With ELSE in SQL

Answered by : samer-saeid

SELECT customer_id, first_name,
CASE WHEN country = 'USA' THEN 'United States of America' WHEN country = 'UK' THEN 'United Kingdom' ELSE 'Unknown Country'
END AS country_name
FROM Customers;

Source : | Last Update : Sun, 29 May 22

Question : SQL CASE Statement

Answered by : samer-saeid

SELECT order_id, customer_id,
CASE WHEN amount >= 400 THEN (amount - amount * 10/100)
END AS offer_price
FROM Orders;

Source : | Last Update : Sun, 29 May 22

Question : SQL CASE

Answered by : samer-saeid

SELECT customer_id, first_name,
CASE WHEN age >= 18 THEN 'Allowed'
END AS can_vote
FROM Customers;

Source : | Last Update : Sun, 29 May 22

Answers related to sql when case

Code Explorer Popular Question For Fortran