＋设为首页 ＋添加到收藏夹
表 A 结构如下：
Name InDate BirthDate
张三 2004-10-1 1981-05-13
李四 2004-10-1 1981-04-25
..................
表B
InDate Name1 Name2 DiffDate
2004-10-1 张三 李四 18
..................
请用一个SQL语句查询同一天入职的年龄差开天数
希望能写下代码，谢谢！
SELECT a.InDate, a.Name as Name1,b.Name AS Name2, DATEDIFF(d, a.BirthDate, b.BirthDate)
AS DiffDate
FROM 表1 as a INNER JOIN
表1 as b ON a.InDate = b.InDate AND a.Name <>b.Name
