查找员工详细信息 [英] Find Employee Details

问题描述

我有两个表Emp(Empno(pk)，Ename，Deptno(fk)，Hiredate)和Dept(Deptno(pk)，Dname，)

我想查询所有部门最近加入的Employee的所有详细信息.

i have two tables Emp(Empno(pk),Ename,Deptno(fk),Hiredate) And Dept(Deptno(pk),Dname,)

I want query to get all details of recently joined Employee in all departments.

推荐答案

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



从Emp E内部联接中选择E.*，D. * Dept on Deptno = D.Deptno
在哪里转换(VARCHAR，E.Hiredate，101)> CONVERT(VARCHAR，DATEADD(DAY，-30，GETDATE())，101)
按D.Dname，E.Hiredate Desc，E.Ename
排序


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


我希望这能帮到您！ :laugh:


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

谢谢，
Imdad

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



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! :laugh:


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

Thanks,
Imdad

这篇关于查找员工详细信息的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！