Home » SQL & PL/SQL » SQL & PL/SQL » Delete 5 th row from a table
Delete 5 th row from a table [message #8615] Thu, 04 September 2003 05:27 Go to next message
p4puls
Messages: 2
Registered: September 2003
Junior Member
How to delete exactly 5 th row in a table.
Pls reply soon

Report message to a moderator

Re: Delete 5 th row from a table [message #8618 is a reply to message #8615] Thu, 04 September 2003 07:14 Go to previous message
ramana
Messages: 51
Registered: December 2000
Member
delete from ram_table
where rowid =
(select rid from
(select rowid rid, rownum rn from ram_table)
where rn = 5)

Report message to a moderator

Previous Topic: sql queries
Next Topic: PL/SQL package becomes invalid
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Thu Apr 25 21:28:51 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.