--The answer is wrong!. It is rare but rows may come when both dates are equal. Check below query with some additional code

CREATE DROP TABLE #TEST

(

FirstDate DATETIME,

LastDate...