Oracle 分组后第一条记录,也可以用来求分组后的最值
SELECT *
FROM (SELECT ROW_NUMBER() OVER(PARTITION BY <PK_FINANCE_ACCOUNT_1> ORDER BY <amassdate> DESC) LEV,
<hx_amass_liquid>.*
FROM <hx_amass_liquid>)
WHERE LEV = 1
ORDER BY <PK_FINANCE_ACCOUNT_2> DESC
<PK_FINANCE_ACCOUNT_1> -- 分组列
<amassdate> -- 排序列
<hx_amass_liquid> -- 表名
<PK_FINANCE_ACCOUNT_2> -- 排序列