UPDATE ATABLE SET A1=(SELECT SUM (A1) FROM ATABLE WHERE LEV = :LEV GROUP BY PAR, LEV ORDER BY LEV, PAR) WHERE id= :id