OraFAQ Forum: SQL & PL/SQL

Home » SQL & PL/SQL » SQL & PL/SQL » Small Help (Oracle 10g R2)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Small Help [message #319257]

Fri, 09 May 2008 08:50

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!

Report message to a moderator

Re: Small Help [message #319260 is a reply to message #319257]

Fri, 09 May 2008 08:55

Frank
Messages: 7901
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

Report message to a moderator

Re: Small Help [message #319263 is a reply to message #319257]

Fri, 09 May 2008 09:01

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

Report message to a moderator

Re: Small Help [message #319267 is a reply to message #319257]

Fri, 09 May 2008 09:25

BlackSwan
Messages: 26766
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?

Report message to a moderator

Re: Small Help [message #319270 is a reply to message #319257]

Fri, 09 May 2008 09:35

Michel Cadot
Messages: 68718
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Have a look at ROW_NUMBER, RANK and DENSE_RANK functions.

Regards
Michel

Report message to a moderator

Previous Topic:	Alter syntax
Next Topic:	conversion of row data to separate columns

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon Dec 02 07:58:34 CST 2024