How can i get the odd rows in my query form a table ?

Question

User1253338400 posted

I am trying to get the odd rows and have the following so far:

Select * from

      (Select rownum as rowNum, ord.* from Orders ord)   ????? <--- I know something goes here in regards to mod but unsure 

Thanks

Answer 1

User452040443 posted

Hi,

Try:

where rownum % 2 = 1

Hope this help

Answer 2

User1253338400 posted

Hi ,

thankyou , you made it look so simple . works perfectly.