Re: Delete exactly the third row in database
"so now you know how the table looks like"
Unfortunatly that's not correct, there is now way to know where the record is stored in the database as they are not inserted in a sequencial order (often rows are stored this way but any number of reasons can mean the rows are moved around).
There isn't really a way to do what you want, mainly because the data and example you present don't really represent a useable data set.
In summary position means nothing in an rdbms, you need to use a key of some sort and order by to have any control on the order of data.
Andrew Gilfrin
------------------
http://gilfster.blogspot.com
My MySQL related Blog
http://www.mysqldevelopment.com
MySQL Stored Procedure,Trigger, View.... (Just about most things these days) Information
Subject
Written By
Posted
Re: Delete exactly the third row in database
July 22, 2005 07:53AM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.