Page 1 of 1

Selecting a perticular row in a table

PostPosted: Fri Nov 09, 2012 5:05 pm
by raghuvanshi
Hi,
How to select 10th row from a table having 100 rows?
Any suggestions are welcome.

Re: Selecting a perticular row in a table

PostPosted: Mon Nov 12, 2012 7:33 pm
by Akatsukami
raghuvanshi wrote:Hi,
How to select 10th row from a table having 100 rows?
Any suggestions are welcome.

At the level of abstraction of a relational table, there is no 10th row, or any nth row; the rows are in no guaranteed order unless one is imposed on them by a ORDER BY clause.