SQL
- 4 ответа
- 0 вопросов
2
Вклад в тег
DELETE FROM gangs_actions
WHERE gangs_actions_id < (SELECT MAX(gangs_actions_id) - 5 FROM (SELECT * FROM gangs_actions) tmp)DELETE FROM gangs_actions
WHERE gangs_actions_id <= (
SELECT gangs_actions_id FROM (SELECT * FROM gangs_actions) as tmp
ORDER BY gangs_actions_id DESC
LIMIT 5,1
)select * from dba_role_privs where (GRANTED_ROLE='CONNECT' OR GRANTED_ROLE='PRESS')select * from dba_role_privs t1 join dba_role_privs t2 on t1.GRANTED_ROLE='CONNECT' and t2.GRANTED_ROLE='PRESS'