You are viewing a single comment's thread. Return to all comments →
mysql solution
select start_date, end_date from (select start_date, row_number() over(order by start_date) as x from projects where start_date not in (select end_date from projects)) as a join (select end_date, row_number() over(order by end_date) as y from projects where end_date not in (select start_date from projects)) as b on a.x = b.y order by datediff(end_date, start_date), 1
SQL Project Planning
You are viewing a single comment's thread. Return to all comments →
mysql solution