Jump to content

Help in SQL query


Hiral
 Share

Recommended Posts

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.

Link to comment
Share on other sites

  • 4 weeks later...

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
 Share

×
×
  • Create New...