如何获得每个部门最近加入的员工详细信息 [英] how to get recently joined Employee details in each department

问题描述

我有两个表Emp和Dept.Emp由Empno(pk)，Deptno(FK)，Ename，Hiredate组成，Dept由Deptno(pk)，Dname，Loc组成.
我想查询所有最近加入该部门的员工的所有详细信息.

i have two tables Emp and Dept. Emp consists of Empno(pk),Deptno(FK),Ename,Hiredate and Dept consists Deptno(pk),Dname,Loc.
I want query to get all details of employee who joined recently in each department.

推荐答案

嗨
这是您最近可以加入公司组织的员工的解决方案.

Hi
Here is the solution you can get recently joined employee in organaization.

SELECT E.*,D.* FROM Emp E INNER JOIN Dept D ON E.Deptno = D.Deptno
WHERE CONVERT(VARCHAR,E.Hiredate,101) > CONVERT(VARCHAR,DATEADD(DAY,-30,GETDATE()),101)
Order by D.Dname, E.Hiredate Desc,  E.Ename

它只会显示最近30天内加入的那些员工.但是如果您想增加或减少天数，请用您的值替换-30.


我希望这能帮到您！ :)


如果您仍然没有解决办法，请告诉我.

谢谢，
Imdad

It will display only those employee who was joined in last 30 days. but if you want increase or decrease day replace -30 with your value.


I hope this will help you! :)


Please let me know, if still you don''t have solution.

Thanks,
Imdad

这篇关于如何获得每个部门最近加入的员工详细信息的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！