SELECT * FROM zamestnanci

SELECT * FROM zamestnanci ORDER BY plat DESC

SELECT * FROM zamestnanci WHERE plat > 40000

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