Selecting a perticular row in a table



Selecting a perticular row in a table

Postby raghuvanshi » Fri Nov 09, 2012 5:05 pm

Hi,
How to select 10th row from a table having 100 rows?
Any suggestions are welcome.
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

Postby 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
User avatar
Akatsukami
Global moderator
 
Posts: 1058
Joined: Sat Oct 16, 2010 2:31 am
Location: Bloomington, IL
Has thanked: 6 times
Been thanked: 51 times


Return to Interview Questions

 


  • Related topics
    Replies
    Views
    Last post