Need a query to extract all the employees who are active in a range of period.
Need a query to extract all the employees who are active in a range of period.
This query should extract all employees who are active from say 01-Jan-2019 to 30-Sep-2019.
In case anyone has been terminated then the termination date needs to be displayed only for those employees during this time period.