I selected option 2 (and only option 2) and was told I was wrong, as I needed to select option 2 & 3. However option 3 returns the results in the following order:
EmpName DateOfLeaving
dcd2000-08-10 00:00:00.000
abc1999-10-10 00:00:00.000
bcd1998-11-11 00:00:00.000
ccdNULL
eedNULL
and the question stated that the solution should be:
EmpName DateOfLeaving
Bcd 11 Nov 1998
Abc 10 Oct 1999
Dcd 10 Aug 2000
Ccd null
Eed null
Therefore I guess thtat the question is worng. At least I should get a point for writing this reply! 😛
Regards,
Phil