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.
  1. Prepare
  2. SQL
  3. Advanced Join
  4. SQL Project Planning
  5. Discussions

SQL Project Planning

  • archita_mehta
     + 2 comments

    Simple MySQL solution without the use of lead and lag window functions

    with start_table as (select start_date, row_number()over(order by start_date) as 'start'
from projects
where start_date not in (select end_date from projects) ),

end_table as (select end_date, row_number()over(order by end_date) as 'end'
from projects
where end_date not in (select start_date from projects))

select s.start_date,e.end_date 
from start_table s, end_table e
where s.start=e.end
order by datediff(e.end_date,s.start_date), s.start_date;