Hiral

Please help anyone.

Hi,

Need help in code trying to find employees old positon number but the job table gives current row position number since the employee was rehired.

Please help.

PLEASE HELP IN A QUERY. i AM TRYING TO DO SELF JOIN WITH A QUERY WHICH 2 OR MOR ELEFT OUTER JOINS IN IT. HOW TO DO SELF JOIN HERE .

THANKS IN ADVANCE.

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.