SELECT * FROM zamestnanci

SELECT * FROM zamestnanci ORDER BY prijmeni

SELECT * FROM zamestnanci ORDER BY prijmeni DESC

SELECT * FROM zamestnanci WHERE id > 2

SELECT * FROM zamestnanci WHERE id > 2 ORDER BY prijmeni

SELECT * FROM jidlo
INNER JOIN kategorie
ON jidlo.id_kategorie = kategorie.id
ORDER BY cena

SELECT jidlo.nazev, cena, kategorie.nazev FROM jidlo
INNER JOIN kategorie
ON jidlo.id_kategorie = kategorie.id
ORDER BY cena

SELECT * FROM jidlo
WHERE nazev LIKE 'p%'

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