In SQL how to find the days are continuous in different leave request and i need to combine as a single request

  Kiến thức lập trình 
 select
      Reques_id  
     ,LeaveFromdate   
     ,LeaveTodate   
      FROM    LeaveTbl LT leto   
      JOIN LeaveTbl_detail LTD  
      on LT.Request_id = LTD.Request_id

I a getting the result as 3 individual rows for 3 unique request

Result:

enter image description here

But i need to get a single row for continuous request like this

Expected Result :

enter image description here

  • sql

LEAVE A COMMENT