Hi,
How to select 10th row from a table having 100 rows?
Any suggestions are welcome.
Selecting a perticular row in a table
Previous topic • Next topic • 2 posts
• Page 1 of 1
Selecting a perticular row in a table
by raghuvanshi » Fri Nov 09, 2012 5:05 pm
- raghuvanshi
- Posts: 43
- Joined: Tue Dec 07, 2010 5:32 pm
- Has thanked: 3 times
- Been thanked: 0 time
Re: Selecting a perticular row in a table
by Akatsukami » Mon Nov 12, 2012 7:33 pm
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.
"You have sat too long for any good you have been doing lately ... Depart, I say; and let us have done with you. In the name of God, go!" -- what I say to a junior programmer at least once a day
-
Akatsukami - Global moderator
- Posts: 1058
- Joined: Sat Oct 16, 2010 2:31 am
- Location: Bloomington, IL
- Has thanked: 6 times
- Been thanked: 51 times
Previous topic • Next topic • 2 posts
• Page 1 of 1
-
- Related topics
- Replies
- Views
- Last post
-
- how to update from perticular record in db2 table
by ashokteja » Fri Apr 29, 2011 10:29 am - 1 Replies
- 3465 Views
- Last post by NicC
Fri Apr 29, 2011 3:25 pm
- how to update from perticular record in db2 table
-
- Adding a new column to an existing table what will be the im
by karthi_ind » Tue Nov 04, 2008 2:45 pm - 5 Replies
- 5128 Views
- Last post by karthi_ind
Thu Nov 06, 2008 12:24 pm
- Adding a new column to an existing table what will be the im