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, end_date, row_number() over(order by end_date) rn
from projects p )
select min(start_date), max(end_date)
from cte1
group by day(end_date) - rn
order by datediff(day,min(start_date),max(end_date)),1
;
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 →
SQL Server:
With cte1 as ( select Start_date, end_date, row_number() over(order by end_date) rn from projects p ) select min(start_date), max(end_date) from cte1 group by day(end_date) - rn order by datediff(day,min(start_date),max(end_date)),1 ;