在SQL Server中计算汇总SQL子查询中的DateADD

发布于 2025-02-04 16:42:07 字数 412 浏览 2 评论 0原文

我在选择语句中创建了一个子查询，该语句将多列汇总到一个列中，然后称为[MaxBoosterDatum]。现在，我需要以计算值的结果执行dateadd计算。任何人都可以帮助/建议我如何实现这一目标吗？

(SELECT MAX(maxBoosterDatum) 
 FROM (VALUES (Quests.[Datum Booster Impfung]), 
              (Quests.[Datum Booster Impfung nach 1]), 
              (Quests.[Datum Booster Impfung nach 2])) AS DatumB(maxBoosterDatum)) AS maxBoosterDatum,

先感谢您！

原文

I created a subquery inside my select statement which aggregates multiple columns into one which then is called [maxBoosterDatum]. Now I need to perform a DateAdd calculation with the result of the calculated value. Can anyone please help/advise me on how I can achieve this?

(SELECT MAX(maxBoosterDatum) 
 FROM (VALUES (Quests.[Datum Booster Impfung]), 
              (Quests.[Datum Booster Impfung nach 1]), 
              (Quests.[Datum Booster Impfung nach 2])) AS DatumB(maxBoosterDatum)) AS maxBoosterDatum,

Thank you in advance!

分享到QQ

分享到微博