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