Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello everyone,
I used Count(distinct EMP_CODE2)-Above(Count(distinct EMP_CODE2)) w.r.t Month and got the Difference of Employees those were present in Previous Month and Not present in Current month.Now i want to which particular EmpCode has Left in Tabular Form.
How can i do that??
Thanks & Regards
Kshitija Shinde
What is your expected result ?
Expected result : Employee who has left the job
provide some sample data
Posted sample data please check out this link .