Dear All,

How to delete the output of this "select first 100 seqno from repl_log
where relationno =11 order by seqno"

Doind this:-

"delete from repl_log where exists (select first 100 seqno from
repl_log where relationno =11 order by seqno) "

seems like deleting the who table instead of 100 records that I wanted
to delete. Anybody know why?

* repl_log is a table. relationno and seqno are fields in repl_log table.
** I want to delete the first 100 data with relationno = 11 sorted by seqno