OraFAQ Forum: SQL & PL/SQL » Using the Sql query to find employees who were recruited on the same day or on neighboring days.

Home » SQL & PL/SQL » SQL & PL/SQL » Using the Sql query to find employees who were recruited on the same day or on neighboring days. (Oracle, 11g, Win 7)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Using the Sql query to find employees who were recruited on the same day or on neighboring days. [message #676483]

Wed, 12 June 2019 01:56

orajav
Messages: 23
Registered: June 2019

Junior Member

Hello!

I need in the Sql-request to display the name, surname and date of commencement of work of employees who were hired on the same day or on neighboring days (for example, one employee left March 2, 2015, and the other on March 3, 2015).

Thanks.

Report message to a moderator

[Message index]

		Using the Sql query to find employees who were recruited on the same day or on neighboring days. By: orajav on Wed, 12 June 2019 01:56
		Re: Using the Sql query to find employees who were recruited on the same day or on neighboring days. By: Michel Cadot on Wed, 12 June 2019 02:17
		Re: Using the Sql query to find employees who were recruited on the same day or on neighboring days. By: orajav on Wed, 12 June 2019 02:24
		Re: Using the Sql query to find employees who were recruited on the same day or on neighboring days. By: orajav on Wed, 12 June 2019 02:41
		Re: Using the Sql query to find employees who were recruited on the same day or on neighboring days. By: Solomon Yakobson on Wed, 12 June 2019 15:09
		Re: Using the Sql query to find employees who were recruited on the same day or on neighboring days. By: orajav on Wed, 12 June 2019 03:27
		Re: Using the Sql query to find employees who were recruited on the same day or on neighboring days. By: Michel Cadot on Wed, 12 June 2019 03:41
		Re: Using the Sql query to find employees who were recruited on the same day or on neighboring days. By: orajav on Thu, 13 June 2019 01:54
		Re: Using the Sql query to find employees who were recruited on the same day or on neighboring days. By: Michel Cadot on Thu, 13 June 2019 02:37
		Re: Using the Sql query to find employees who were recruited on the same day or on neighboring days. By: orajav on Thu, 13 June 2019 03:35
		Re: Using the Sql query to find employees who were recruited on the same day or on neighboring days. By: orajav on Thu, 13 June 2019 03:59
		Re: Using the Sql query to find employees who were recruited on the same day or on neighboring days. By: cookiemonster on Thu, 13 June 2019 04:04
		Re: Using the Sql query to find employees who were recruited on the same day or on neighboring days. By: orajav on Thu, 13 June 2019 06:28
		Re: Using the Sql query to find employees who were recruited on the same day or on neighboring days. By: cookiemonster on Thu, 13 June 2019 09:32
		Re: Using the Sql query to find employees who were recruited on the same day or on neighboring days. By: orajav on Thu, 13 June 2019 10:48
		Re: Using the Sql query to find employees who were recruited on the same day or on neighboring days. By: Solomon Yakobson on Thu, 13 June 2019 11:49
		Re: Using the Sql query to find employees who were recruited on the same day or on neighboring days. By: orajav on Thu, 13 June 2019 11:59
		Re: Using the Sql query to find employees who were recruited on the same day or on neighboring days. By: Solomon Yakobson on Thu, 13 June 2019 12:05
		Re: Using the Sql query to find employees who were recruited on the same day or on neighboring days. By: orajav on Thu, 13 June 2019 12:46
		Re: Using the Sql query to find employees who were recruited on the same day or on neighboring days. By: orajav on Wed, 12 June 2019 04:22
		Re: Using the Sql query to find employees who were recruited on the same day or on neighboring days. By: Michel Cadot on Wed, 12 June 2019 04:40
		Re: Using the Sql query to find employees who were recruited on the same day or on neighboring days. By: orajav on Wed, 12 June 2019 04:46

Previous Topic:	How to pass input parameter(Inside a procedure) with more than 4000 characters as comma separated va
Next Topic:	Incorrect work of the sql query with JOIN.

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Tue Apr 23 14:36:58 CDT 2024