Hello Everyone,
I am writing a query in SQL to pull the first date an employee became a teacher with no break in service. using the job table here to find effective date when a employee became teacher like example.
1. Teacher - 1/1/18.
2. coordinator- 2/1/18
3. Teacher- 3/1/18
Here in result I need the last entry as there is no gap in that title now.