Oracle SQL TUTORIAL – IF condition using CASE and DECODE - An Example

In this video, we shall see how case and decode is used in real time scenario. SQL used in the video is given below.

SELECT * FROM emp_test ORDER BY gender;

count_of_employees Count_of_Male_Employees Count OF Female Employees --
15 5 8


select count(*) " Total Employees" from emp_test;

select gender,count(*) " Total Employees" from emp_test group by gender;

select sum(decode(gender,'M',1,0)) Count_OF_Male_Employees from emp_test;

select sum(case gender when 'F' then 1 else 0 end) as Count_OF_FeMale_Employees from emp_test;

SELECT count(*) " Total Employees" ,
sum(decode(gender,'M',1,0)) Count_OF_Male_Employees,
sum(case gender when 'F' then 1 else 0 end) Count_OF_Female_Employees
from emp_test;

[chamilautubed]

Thank you very much for uploading the tutorial