获取员工的详细信息 [英] Get details of employees

问题描述

我有两个表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.

推荐答案

Ramesh Reddy11111写道:

Ramesh Reddy11111 wrote:

最近加入的人

这是什么意思应该有一天的限制，例如一周或一个月或15天！

从今天起15天内您将前往这里:

What do you mean by this? There should be a day limit like a week or a month or 15 days!

Here you go for within 15 days from today:

SELECT 
  Emp.Empno, Emp.Ename, Emp.Hiredate, Dept.Dname, Dept.Loc
FROM
  Emp INNER JOIN Dept ON Emp.Deptno = Dept.Deptno
WHERE
  Emp.Hiredate BETWEEN (GETDATE()) AND (GETDATE()-15)

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