–save the whole sum into a variable
summa = select sum(val) from sometable;
select * from sometable o where ( select sum(val)from sometable i where i.val <= o.val ) >= 0.6*summa;
–save the whole sum into a variable
summa = select sum(val) from sometable;
select * from sometable o where ( select sum(val)from sometable i where i.val <= o.val ) >= 0.6*summa;
名师互学网 版权所有 (c)2021-2022 ICP备案号：晋ICP备2021003244-6号
