先排序再获取GROUP BY 后的第一位
select
MATNR,
FIRST_VALUE( KWMENG order by MATNR , KWMENG desc )
from "SAPBWPRD"."ZTL_HHWFH"
group by MATNR
先排序再获取GROUP BY 后的第一位
select
MATNR,
FIRST_VALUE( KWMENG order by MATNR , KWMENG desc )
from "SAPBWPRD"."ZTL_HHWFH"
group by MATNR