this i sample for my table in DB
here Gate 1 start date should be (2014-01-27) and end date for Gate 1 should be the start of Gate 2 (2015-03-27)
Gate 2 start date should be (2015-03-27) and end date for Gate 2 should be the start of Gate 3 (2016-03-27)
Gate 3 start should be (2016-03-27) and end of Gate 3 should be start of Gate 4 (2017-06-27)
and the same for Gate 4
so how can i do that ,i think here i should get values from different rows
any help would be appreciated
thanks .
Go to the complete details ...