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' |