OraFAQ Forum: SQL & PL/SQL » even & odd rows

Home » SQL & PL/SQL » SQL & PL/SQL » even & odd rows

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

even & odd rows [message #232031]

Thu, 19 April 2007 02:28

oradat
Messages: 18
Registered: April 2007

Junior Member

How to write an sql Query to seprate even and odd rows in a
table .

Report message to a moderator

Re: even & odd rows [message #232037 is a reply to message #232031]

Thu, 19 April 2007 02:38

Maaher
Messages: 7065
Registered: December 2001

Senior Member

Be specific:

Define even and odd. Oracle has NO ORDER in its rows. It is YOU (the developer) who decides the order.
What do you want: split rows of a single column in 2 columns? Or do you want to filter out certain rows based on their rank in a given order?

And, for crying out loud, learn how to search the board. You will find a search button on the top menu of the forum. Use it.

MHE

Report message to a moderator

Re: even & odd rows [message #232038 is a reply to message #232031]

Thu, 19 April 2007 02:39

shanthkumaar
Messages: 156
Registered: February 2007
Location: india,chennai

Senior Member

hi

just ask the same question with even and odd in the search option of these forum and you will find these links.

link1

link

link

link3

a bit slow................. Embarassed