SELECT * FROM zamestnanci

SELECT * FROM zamestnanci ORDER BY plat DESC

SELECT * FROM zamestnanci WHERE plat > 50000

SELECT * FROM zamestnanci WHERE plat < 50000 ORDER BY plat DESC

// propojení tabulek + alias
SELECT jidlo.nazev, cena, kategorie.nazev AS kategorie
FROM jidlo INNER JOIN kategorie ON jidlo.id_kategorie = kategorie.id

SELECT * FROM jidlo
WHERE nazev LIKE '%pizza%'

// nový záznam
INSERT INTO zamestnanci (jmeno, prijmeni, narozeni, plat)
VALUES ('Diego', 'Maradona', 2000, 10);

// úprava záznamu
UPDATE zamestnanci SET plat = 200000
WHERE id = 8;

UPDATE zamestnanci SET plat = 1.1*plat;

// smazat záznam
DELETE FROM zamestnanci
WHERE id = 9