Курс «SQL»

SELECT * FROM users; SELECT name FROM users; SELECT id, name FROM users; SELECT DISTINCT category FROM products; SELECT * FROM users WHERE id = 1; SELECT id, name, email FROM users WHERE active = 1; SELECT name, email FROM users; SELECT * FROM products WHERE price > 100; INSERT INTO users (name, email) VALUES ('John', 'john@mail.com'); INSERT INTO users VALUES (1, 'John', 'john@mail.com'); INSERT INTO users SELECT * FROM temp_users; INSERT INTO products (name, price) VALUES ('Product', 99.99); INSERT INTO orders (user_id, total) VALUES (1, 150.00); UPDATE users SET name = 'Jane'; UPDATE users SET name = 'Jane', email = 'jane@mail.com' WHERE id = 1; UPDATE products SET price = price + 10 WHERE id = 1; UPDATE users SET active = 1 WHERE id = 5; UPDATE products SET price = price * 1.1 WHERE category = 'Electronics'; DELETE FROM users WHERE id = 1; DELETE FROM orders WHERE status = 'cancelled'; TRUNCATE TABLE temp_data; DELETE FROM products WHERE stock = 0; SELECT name, email FROM users WHERE active = 1 AND created_at > '2024-01-01'; INSERT INTO archive_users SELECT * FROM users WHERE created_at < '2020-01-01'; UPDATE products SET discount = 0.2 WHERE price > 100 AND category = 'Sale'; SELECT * FROM users WHERE age > 18 AND active = 1; SELECT * FROM users WHERE role = 'admin' OR role = 'moderator'; SELECT * FROM users WHERE NOT deleted = 1; SELECT * FROM products WHERE (price > 100) AND (category = 'Electronics' OR category = 'Computers'); SELECT * FROM orders WHERE status = 'completed' AND total > 100; SELECT * FROM users WHERE (age >= 18 AND age <= 65) OR role = 'admin'; SELECT * FROM users WHERE age > 18; SELECT * FROM users WHERE age >= 18 AND age <= 65; SELECT * FROM products WHERE price < 100; SELECT * FROM products WHERE price <= 100; SELECT * FROM users WHERE name <> 'John'; SELECT * FROM products WHERE price >= 50 AND price <= 200; SELECT * FROM users WHERE id IN (1, 2, 3); SELECT * FROM users WHERE name IN ('John', 'Jane', 'Bob'); SELECT * FROM users WHERE id NOT IN (1, 2, 3);

Показаны первые 40 из 173.