You are viewing a single comment's thread. Return to all comments →
with temp1 as( select start_date , ROW_NUMBER() OVER (order by start_date) as x_row from projects where start_date not in (select end_date from projects) ), temp2 as ( select end_date , ROW_NUMBER() OVER (order by end_date) as y_row from projects where end_date not in (select start_date from projects) ) select start_date, end_date from temp1 join temp2 on x_row = y_row order by end_date - start_date
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 →