我在这个网站上进行了广泛的搜索,但找不到解决方案。
以下是我的查询示例:
SELECT
ActivityID,
Hours = (CASE
WHEN ActivityTypeID <> 2 THEN
FieldName = (Some Aggregate Sub Query),
FieldName2 = (Some other aggregate sub query)
WHEN ActivityTypeID = 2 THEN
FieldName = (Some Aggregate Sub Query with diff result),
FieldName2 = (Some Other Aggregate Sub Query with diff result)
END)
显然我省略了查询的很多部分,我只是想看看是否可能。
我知道我可能可以两次使用 "CASE" 但是想问一下...