SELECT * FROM actor; | Wszystkie dane z 'actor' | |
SELECT first_name, last_name FROM actor; | Wyświetl first_name, last_name z 'actor' | |
DESCRIBE actor; | Wyświetl informacje o 'actor' | |
-- | za pomocą jakich znaków napisać komentarz ? | |
SELECT first_name, last_name FROM actor ORDER BY last_name; | Wyświetl first_name, last_name z 'actor' w kolejności A-Z ( dla last_name ) | |
SELECT first_name, last_name FROM actor ORDER BY last_name DESC; | Wyświetl first_name, last_name z 'actor' w kolejności Z-A ( dla last_name ) | |
SELECT title, price FROM film ORDER BY title DESC, price; | 'title', 'price' z 'film' gdzie title malejaco a price rosnaco. | |
SELECT title, rental_rate FROM film WHERE rental_rate < 3 ORDER BY rental_rate DESC; | Wyświetl 'title' i 'rental_rate' z 'film' dla: 'rental_rate(malejaco) mniejsze niz 3' | |
SELECT title, rental_rate FROM film WHERE rental_rate BETWEEN 1 AND 3; | Wyświetl 'title', 'rental_rate' z 'film' gdzie rental_rate(1<x<3) | |
SELECT description FROM film WHERE description LIKE "%drama%"; | Wyświetl rekordy 'description' z 'film' które zawierają słowo: 'drama' | |