我有这样的查询:
select
FirstName, LastName, BirthDate,
GETDATE() AS [Today],
CAST (DATEDIFF (DD, BirthDate, GETDATE())/365.25 AS INT) AS [Age]
FROM
Employees
WHERE CAST (DATEDIFF (DD, BirthDate, GETDATE())/365.25 AS INT) >=55
ORDER BY LastName ASC
我想要找到最大、最小和平均年龄,但是我似乎做不到。该如何实现?
select
FirstName, LastName, BirthDate,
GETDATE() AS [Today],
CAST (DATEDIFF (DD, BirthDate, GETDATE())/365.25 AS INT) AS [Age],
MIN (DATEDIFF (DD, BirthDate, GETDATE())/365.25 AS INT)
FROM
Employees
WHERE
CAST (DATEDIFF (DD, BirthDate, GETDATE())/365.25 AS INT) >=55
ORDER BY
LastName ASC
错误:
消息 195,级别 15,状态 10,行 5
'MIN' 不是已识别的内置函数名。