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: 25050
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: 4644
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: Sat Dec 10 13:07:55 CST 2016

Total time taken to generate the page: 0.22653 seconds