如何选择总计不超过60％的值

–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;