Home » SQL & PL/SQL » SQL & PL/SQL » Small Help (Oracle 10g R2)
Small Help [message #319257] Fri, 09 May 2008 08:50 Go to next message
rman_yv
Messages: 9
Registered: February 2008
Junior Member
Hi everyone

can anyone help me in getting nth row in a table without using pseudo columns.

Atleast small idea to get it!
Re: Small Help [message #319260 is a reply to message #319257] Fri, 09 May 2008 08:55 Go to previous messageGo to next message
Frank
Messages: 7880
Registered: March 2000
Senior Member
Why do you exclude any solution beforehand that uses pseudocolumns?
What solutions did you come up with yourself, or where did you get stuck trying?
What solutions were you able to find so far?

Next time please use a more descriptive title for your threads
Re: Small Help [message #319263 is a reply to message #319257] Fri, 09 May 2008 09:01 Go to previous messageGo to next message
rman_yv
Messages: 9
Registered: February 2008
Junior Member
Hi Frank,

Thanx for your reply...
That's just a small testing to myself but am not getting any solution/idea for the same.
so want to clarify whether is possible, if yes, give me some clue to get it so that i'll try on it
Re: Small Help [message #319267 is a reply to message #319257] Fri, 09 May 2008 09:25 Go to previous messageGo to next message
BlackSwan
Messages: 25046
Registered: January 2009
Location: SoCal
Senior Member
rman_yv wrote on Fri, 09 May 2008 06:50
Hi everyone

can anyone help me in getting nth row in a table without using pseudo columns.

Atleast small idea to get it!


A table contains a collection of rows;
much like a basket contains a collection of colored balls.

Which ball is the nth ball in the basket?
Re: Small Help [message #319270 is a reply to message #319257] Fri, 09 May 2008 09:35 Go to previous message
Michel Cadot
Messages: 64139
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Have a look at ROW_NUMBER, RANK and DENSE_RANK functions.

Regards
Michel
Previous Topic: Alter syntax
Next Topic: conversion of row data to separate columns
Goto Forum:
  


Current Time: Thu Dec 08 16:26:50 CST 2016

Total time taken to generate the page: 0.08726 seconds