SQL MAX 函数未能筛选最大值。

[Miss_Lina]

请教问啥下面这个query 没能在‘TEST’列显示最大值呢？MAX函数用得不对么？
如下query:

SELECT
WeeksSinceLaunch, weeks_in_channel,model,operator

,MAX(integer(WeeksSinceLaunch)) TEST

FROM [motorola.com:dataservices:zPlayground.M_Science_Native_Phase_II]

where operator = 'AT&T'
AND MODEL='Galaxy S9'
GROUP BY 1,2,3,4

[吉普赛的歌]

你的分组列那么多， 当然看不出效果。

SELECT WeeksSinceLaunch,
       MAX(integer(WeeksSinceLaunch)) TEST
FROM   [motorola.com:dataservices:zPlayground.M_Science_Native_Phase_II]
WHERE  operator = 'AT&T'
       AND MODEL = 'Galaxy S9'
GROUP BY
       WeeksSinceLaunch

[Hello World,]

如果要显示明细又要取最大值得用开窗函数不用group by

max(ss) over (PARTITION BY xx)