We value your feedback.
Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!
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 SQL> / where first_name in ('priya','joshua') ) x,t500 Error comes : Table or view not exist
Join the community of 500,000 technology professionals and ask your questions.