What is pivot table. Why we have to use pivot table to generate required number of rows.
Please explain me what is the use of pivot table.
1 select sum( case when to_char(josh_date + t500.id -1 ,'Dy') in ('SAT','SUN')
2 then 0 else 1 end) as days from (
3 select max(case when first_name = 'priya' then hire_date end ) as priya_date,
4 max( case when first_name = 'joshua' then hire_date end) as josh_date
5 from employee
6 where first_name in ('priya','joshua') ) x,t500
7* where t500.id <= priya_date - josh_date + 1
where first_name in ('priya','joshua') ) x,t500
Error comes :
Table or view not exist