CASE is like “IF-ELSE IF-THEN-ELSE” .
CASE statement is used to check “Matched” and “UnMatched” condition.If there are more condition in CASE statement and first condition matches then return values for first condition .
If first condition does not match then it will return values for ElSE condition.
WHEN condition1 THEN result1
WHEN condition2 THEN result2
There is created “Employee” table in a database
The following query will return records by using “CASE” statements.
CASE WHEN Departmentid=101 THEN 'IT DEPARTMENT'
WHEN Departmentid=102 THEN 'SALES DEPARTMENT'
WHEN Departmentid=103 THEN 'FINANACE DEPARTMENT'
ELSE 'TECHNICAL SUPPORT'
END AS 'Department Wise Employee'
If you want to sell your readymade software to the genuine clients or businessman, list your software with details and demo links.
Clients will find it using our advanced search filter and will contact you directly.
No any charge for the product lsiting.