用下记语句,我发现有FIRST与用LAST求出的值是一样的,
因刚学分析函数,对这个逻辑不是太了解,请教:
select location_no,
max(qty_onhand) keep (dense_rank first order by location_no) maxv,
min(qty_onhand) keep (dense_rank last order by location_no) minv
from inventory_part_in_stock_loc
group by location_no
上述语句中,将FIRST改为LAST或将LAST改为FIRST,
结果都是一样的,WHY