SELECT * FROM `REVISTE` WHERE `an_aparitie`='2014' SELECT MIN(`pret`) FROM `REVISTE` UPDATE `REVISTE` SET `nr_ex`=`nr_ex`*1.1 WHERE `cod`='500'