我没有学个oracle,
delete l_system_log where seq_no in(select top 60 from l_system_log order by update_time asc)
用oracle怎样实现这条语句,感激不尽
delete l_system_log where seq_no in(select top 60 from l_system_log order by update_time asc)
用oracle怎样实现这条语句,感激不尽
调试欢乐多
delete l_system_log
where seq_no in(select seq_no from (
select rownum rn,seq_no from l_system_log order by update_time asc)
where rn<=60)
where seq_no in(select seq_no from (
select seq_no from l_system_log order by update_time asc)
where rownum<=60)