Oracle_分组内查寻最大最小值
Oracle_分组内查找最大最小值
查询地区内，最大最小年龄
SELECT a.aac001,
a.aac002,
a.aac003,
min(aac006) over(partition by aab034) "minage",
aac006,
max(a.aac006) over(partition by aab034) "maxage"
FROM ac01 a
order by a.aac006;