請教問啥下面這個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
uj5u.com熱心網友回復：
你的分組列那么多， 當然看不出效果。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
uj5u.com熱心網友回復：
如果要顯示明細又要取最大值得用開窗函式不用group bymax(ss) over (PARTITION BY xx)
轉載請註明出處，本文鏈接：https://www.uj5u.com/shujuku/39729.html
標籤：應用實例