Home » SQL & PL/SQL » SQL & PL/SQL » Nth record
Nth record [message #236339] Wed, 09 May 2007 12:10 Go to next message
t.guru
Messages: 5
Registered: May 2007
Junior Member
How to select an Nth record from a table at run time.

N=Any row from a table.

Re: Nth record [message #236341 is a reply to message #236339] Wed, 09 May 2007 12:13 Go to previous messageGo to next message
BlackSwan
Messages: 25130
Registered: January 2009
Location: SoCal
Senior Member
new user t.guru seems to be unwilling or incapable of searching this forum or using Google to answer this FAQ.
Re: Nth record [message #236342 is a reply to message #236339] Wed, 09 May 2007 12:14 Go to previous message
joy_division
Messages: 4669
Registered: February 2005
Location: East Coast USA
Senior Member
No such thing N-th record in a relational database unless you use an order by clause. Search for Top N or Nth record. Locked.
Previous Topic: external tables
Next Topic: query rows as columns
Goto Forum:
  


Current Time: Mon Jan 16 21:35:41 CST 2017

Total time taken to generate the page: 0.17175 seconds