Question: What is the correct syntax for the CASE statement? Select an answer: SELECT FirstName, LastName, Company, Country, START CASE WHEN Country = 'USA' THEN 'Local'

What is the correct syntax for the CASE statement?
Select an answer:
SELECT
FirstName,
LastName,
Company,
Country,
START CASE
WHEN Country = 'USA' THEN 'Local'
ELSE 'Global'
END AS Region
FROM
Customer
ORDER BY
Region
SELECT
FirstName,
LastName,
Company,
Country,
CASE
WHEN Country = 'USA' THEN 'Local'
ELSE 'Global'
END CASE AS Region
 What is the correct syntax for the CASE statement? Select an

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!