Oracle:"Select rowid from ps_job Where Mod(rownum,2)=0"?

0 ⤊

Oracle:"Select rowid from ps_job Where Mod(rownum,2)=0"?

This is not returning any rows why?

2006-08-18 20:57:56 · 2 answers · asked by Soni 1 in Computers & Internet ➔ Programming & Design

2 answers

hmm.. try this
select rowid from (select rownum r, rowid from ps_jobs) where mod(r, 2)=0

And if this works for you, check this
http://www.adp-gmbh.ch/ora/sql/rownum.html

2006-08-18 21:05:54 · answer #1 · answered by Neil 5 · 0⤊ 0⤋

refer to oracle manual

2006-08-19 04:05:45 · answer #2 · answered by Vijay 2 · 0⤊ 1⤋