consecutive records without any gap

Database
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