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 jidlo.nazev, cena, kategorie.nazev AS kategorie FROM jidlo INNER JOIN kategorie ON jidlo.id_kategorie=kategorie.id ORDER BY cena

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