max()和min()函数
select a,max(b) from t group by a
select a,min(b) from t group by a
max和min函数是取某一列中的最大或者最小值
greatest()和least()函数
select greatest(-1, 0, 5, 8) --8
select least(-1, 0, 5, 8) -- -1
greatest和least函数是取某一行中的最大或者最小值,但一定是比较相同类型的数据,如果数据类型不同,返回null
max() over()和min() over()函数
select a
,b
,max(b) over(partition by a) as max_val
,min(b) over(partition by a) as min_val
from t