We use cookies to ensure you have the best browsing experience on our website. Please read our cookie policy for more information about how we use cookies.
with CTE1 as (
select start_date,
ROW_NUMBER() over (order by start_date) as str_rank
from projects
where start_date not in (select end_date from projects)
)
,
CTE2 as (
select end_date,
ROW_NUMBER() over (order by end_date) as end_rank
from projects
where end_date not in
(select start_date from projects)
)
select start_date, end_date from
CTE1, CTE2
where str_rank = end_rank
order by Datediff(day,start_date,end_date), start_date
Cookie support is required to access HackerRank
Seems like cookies are disabled on this browser, please enable them to open this website
SQL Project Planning
You are viewing a single comment's thread. Return to all comments →
with CTE1 as ( select start_date, ROW_NUMBER() over (order by start_date) as str_rank from projects where start_date not in (select end_date from projects) ) , CTE2 as ( select end_date, ROW_NUMBER() over (order by end_date) as end_rank from projects where end_date not in (select start_date from projects) )
select start_date, end_date from CTE1, CTE2 where str_rank = end_rank order by Datediff(day,start_date,end_date), start_date