You are viewing a single comment's thread. Return to all comments →
ms sql:
with first_date as ( select p.start_date, p.end_date from projects as p left join projects as pp on p.start_date = pp.end_date where pp.end_date is null union all select fd.start_date, ppp.end_date from first_date as fd join projects as ppp on fd.end_date = ppp.start_date ) select start_date, max(end_date) from first_date group by start_date order by count(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 →
ms sql: