OraFAQ Forum: SQL & PL/SQL » deleting rows having even rownum

Home » SQL & PL/SQL » SQL & PL/SQL » deleting rows having even rownum

Mon, 04 March 2002 23:41

jeya
Messages: 18
Registered: January 2001

Junior Member

how to delete rows having even row numbers

Tue, 05 March 2002 00:05

pratap kumar tripathy
Messages: 660
Registered: January 2002

Senior Member

delete from deletetest
where rowid in
(select rwd from
(select rowid rwd,rownum rn from deletetest)
where mod(rn,2)=0
)
/

Previous Topic:	sql response
Next Topic:	execute permissions

Goto Forum:

]

Current Time: Wed Apr 24 17:13:29 CDT 2024