#SQL #POSTGRESQL 🐘
Выбрать записи за последние 15 минут
SELECT created_at FROM events WHERE created_at > NOW() - INTERVAL '15 minutes';
Выбрать записи за последние 15 минут
SELECT created_at FROM events WHERE created_at > NOW() - INTERVAL '15 minutes';
#SQL Swap rows
UPDATE fruit a
INNER JOIN fruit b ON a.id <> b.id
SET a.color = b.color,
a.name = b.name,
a.calories = b.calories
WHERE a.id IN (2,5) AND b.id IN (2,5)