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
Hi,
Try:
where rownum % 2 = 1
Hope this help
Hi ,
thankyou , you made it look so simple . works perfectly.