consecutive records without any gap

The Teradata Database channel includes discussions around advanced Teradata features such as high-performance parallel database technology, the optimizer, mixed workload management solutions, and other related technologies.

consecutive records without any gap


Can some one please help me writting this query 


There is a table with employee name, project, proj_start_date,proj_end_date

I need to find out all those employees who are working projects consecutively without any gap between projects or with a gap of 1 or 2 days

  • Database
  • SQL ASsistant