Home » SQL & PL/SQL » SQL & PL/SQL » even & odd rows
even & odd rows [message #232031] Thu, 19 April 2007 02:28 Go to next message
oradat
Messages: 18
Registered: April 2007
Junior Member
How to write an sql Query to seprate even and odd rows in a
table .
Re: even & odd rows [message #232037 is a reply to message #232031] Thu, 19 April 2007 02:38 Go to previous messageGo to next message
Maaher
Messages: 7062
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
Re: even & odd rows [message #232038 is a reply to message #232031] Thu, 19 April 2007 02:39 Go to previous messageGo to next message
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
regards
shanth

[Updated on: Thu, 19 April 2007 02:40]

Report message to a moderator

Re: even & odd rows [message #232412 is a reply to message #232037] Fri, 20 April 2007 07:39 Go to previous messageGo to next message
oradat
Messages: 18
Registered: April 2007
Junior Member
Even rows only .is there any way
Re: even & odd rows [message #232415 is a reply to message #232038] Fri, 20 April 2007 07:44 Go to previous message
oradat
Messages: 18
Registered: April 2007
Junior Member
Thanks Buddy for u r help .
Previous Topic: linking to an image on my webspace/hard drive to be displayed on a web site?
Next Topic: ORA-29280: Invalid directory path
Goto Forum:
  


Current Time: Fri Dec 09 05:46:35 CST 2016

Total time taken to generate the page: 0.08685 seconds