is-coursework/report/data-model/sql/precedents/log1-get-by-time.sql

6 lines
175 B
SQL

-- Аудит за временной интервал
SELECT at, actor_type, actor_id, action, resource, ip
FROM event
WHERE at >= $1 AND at < $2
ORDER BY at DESC
LIMIT 1000;