Большая шпаргалка по основным запросам SQL.

SELECT * FROM articles WHERE MATCH(title, content) AGAINST('поиск');

CREATE FULLTEXT INDEX idx_fulltext ON articles(title, content);

SELECT * FROM articles 
WHERE MATCH(title, content) AGAINST('+поиск -необходимое' IN BOOLEAN MODE);

Автор: Лузанов П
Год: 2021

SELECT user_id, balance
FROM users
WHERE balance > (SELECT AVG(balance) FROM users);

SELECT name
FROM employees e1
WHERE salary > (SELECT AVG(salary) FROM employees e2 WHERE e1.department = e2.department);

SELECT customer_name
FROM customers c
WHERE EXISTS (SELECT 1 FROM orders o WHERE o.customer_id = c.customer_id);

Автор: Полищук Ю.В.
Год: 2021