更新时间:2022-12-07 11:15:23
最近加入的人
这是什么意思应该有一天的限制,例如一周或一个月或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)