且构网

分享程序员开发的那些事...
且构网 - 分享程序员编程开发的那些事

获取员工的详细信息

更新时间:2022-12-07 11:15:23

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)