20,809
社区成员
发帖
与我相关
我的任务
分享
select zoneno,balance,count1,sum1
from (select zoneno,
balance,
row_number() over(partition by zoneno, order by serialno desc) rn,
count(1) over(partition by zoneno) count1,
sum(amount) over(partition by zoneno) sum1
from table ) t
where t.rn = 1;
select a.zoneno,a.balance,b.count1,b.sum1
from table a
inner join (select zoneno,max(serialno) max_serialno,count(1) count1,sum(amount) sum1 from table group by zoneno) b
on (a.zoneno = b.zoneno and a.serialno = b.max_serialno);