Originally posted by padmaratna: hello friends please tell me how to select 2nd and 3rd row from any table please give me query in detail
No such thing. The tables in a relational database represent an unordered set. You have to supply the ordering yourself. Once you supply the ordering, then you can get a particular row in that ordering.
On Oracle and some other databases, to get the 3rd row for some ordering, you could do something like:
Some people are confused because many databases will initially return rows to you in the order they were inserted; however, after some time (particularly after deletes, or updates that make VARCHAR values significantly bigger), the database will reuse or reorganize the internal storage and the "storage order" becomes more or less random.