xxxxxxxxxx
--CREATE SOME SAMPLE DATA
CREATE TABLE Casedata
(
NAME VARCHAR(10)
);
INSERT INTO Casedata VALUES ('Test 1');
INSERT INTO Casedata VALUES ('Test 2');
INSERT INTO Casedata VALUES ('None');
-- CASE WHEN IN SQL
SELECT NAME,
CASE
WHEN NAME = 'Test 1' THEN 'The value is 1'
WHEN NAME = 'Test 2' THEN 'The value is 2'
ELSE 'Sorry no Match'
END
FROM Casedata
xxxxxxxxxx
INSERT INTO HumanResources.departmentcopy(DepartmentID, GroupName, Name, temp)
SELECT DepartmentID,
GroupName,
Name,
CASE WHEN DepartmentID = 1 AND Name = 'Engineering and Research'
THEN 'sucessful' ELSE 'unsucessful' END
FROM HumanResources.department
xxxxxxxxxx
CASE
WHEN SUBSTRING(applications.pinfl, 1,1) IN ('3','5','7') THEN 'Erkak'
WHEN SUBSTRING(applications.pinfl, 1,1) IN ('2','4','6') THEN 'Ayol'
ELSE 'Topilmadi'
END as gender
xxxxxxxxxx
SELECT column_name,
CASE
WHEN boolean_condition THEN 'Result_1'
WHEN boolean_condition THEN 'Result_2'
ELSE 'Result_3'
END AS result_column_name
FROM table_name_1
LEFT JOIN table_name_2 ON
CASE
WHEN boolean_condition THEN 'Boolean_Result_1'
WHEN boolean_condition THEN 'Boolean_Result_2'
ELSE 'Boolean_Result_3'
END;
xxxxxxxxxx
SELECT column1, column2,
CASE
WHEN condition1 THEN value1
WHEN condition2 THEN value2
ELSE value3
END AS result_column
FROM your_table;