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.
Enthusiast

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