How can i get the odd rows in my query form a table ?[Answered] RSS

• • Reply
  robby32

  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

• • Reply
  imapsp

  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:

  where rownum % 2 = 1

  Hope this help

  https://www.imoveisemexposicao.com.br/imoveis-venda-guarulhos-residencial-casa
• • Reply
  robby32

  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.