Selecting a perticular row in a table

Post Reply Previous topicNext topic
raghuvanshi
Posts: 43
Joined: Tue Dec 07, 2010 5:32 pm
Skillset: COBOL,JCL,DB2,VSAM,CA7
Referer: Google

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.
Top
User avatar
Akatsukami
Global moderator
Posts: 1058
Joined: Sat Oct 16, 2010 2:31 am
Skillset: Rexx, JCL, DB2/SQL, TSO/ISPF, PL/I
Referer: ibmmainframes
Location: Bloomington, IL
Contact:
Contact Akatsukami

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
Top
Post Reply Previous topicNext topic
  • Similar Topics
    Replies
    Views
    Last post

Return to “Interview Questions”