Hi,
ID - EmpId - Start Date - End Date
1 - A - 07/05/2013 - 08/05/2013
2 - A - 09/05/2013 - NULL
3 - B - 09/05/2013 - 10/05/2013
4 - C - 08/05/2013 - 09/05/2013
5 - C - 09/05/2013 - NULL
How to select the records between start date from 09/05/2013 to end date 09/05/2013 OR NULL
Required output:
2 - A - 09/05/2013 - NULL
3 - B - 09/05/2013 - 10/05/2013
4 - C - 08/05/2013 - 09/05/2013
5 - C - 09/05/2013 - NULL
No comments:
Post a Comment