Last post Jun 12, 2020 01:48 AM by robby32
Member
283 Points
1005 Posts
Jun 11, 2020 11:06 PM|robby32|LINK
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
Participant
1130 Points
299 Posts
Jun 12, 2020 01:35 AM|imapsp|LINK
Hi,
Try:
where rownum % 2 = 1
Hope this help
Jun 12, 2020 01:48 AM|robby32|LINK
Hi ,
thankyou , you made it look so simple . works perfectly.
Member
283 Points
1005 Posts
How can i get the odd rows in my query form a table ?
Jun 11, 2020 11:06 PM|robby32|LINK
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
Participant
1130 Points
299 Posts
Re: How can i get the odd rows in my query form a table ?
Jun 12, 2020 01:35 AM|imapsp|LINK
Hi,
Try:
Hope this help
Member
283 Points
1005 Posts
Re: How can i get the odd rows in my query form a table ?
Jun 12, 2020 01:48 AM|robby32|LINK
Hi ,
thankyou , you made it look so simple . works perfectly.