SELECT * FROM zamestnanci
SELECT * FROM zamestnanci ORDER BY prijmeni 
SELECT * FROM zamestnanci ORDER BY prijmeni DESC

INSERT INTO zamestnanci (jmeno, prijmeni, narozeni, plat)
VALUES ('Adam', 'Pioisoaid', '1993', '20000');

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




INSERT INTO zamestnanci (jmeno, prijmeni, narozeni, plat)
VALUES ('Pavel', 'SvatĂ˝', 2001, 100);