usmanahmad

 Profile Answers by usmanahmad 

• Feb 23rd, 2009

 

Hi there Thanks for your question, if I am not wrong you are asking for odd or even rows based on rownum? Am I right?

If yes then your answer is below

if you are looking for even number rows (based on rownom) then you can use following query.SELECT usernameFROM (SELECT ROWNUM num, usernameFROM dba_users)

WHERE MOD (num, 2) = 0;

if you are looking odd number rows (based on Rownum) then use following query

SELECT usernameFROM (SELECT ROWNUM num, usernameFROM dba_users)WHERE MOD (num, 2) = 1;

Plase let me know if you have any issue(s).
Thank you. 
Usman


 

aditya_12

 Profile Answers by aditya_12 Questions by aditya_12

• Sep 25th, 2009

 

select * from (select rownum as rwid, a.* from (SELECT empno,ename,job,mgr,hiredate,sal,comm,deptno from emp) a) where mod(rwid,2) = 1

This query will be helpful to find out the odd records for even records just change to mod(rwid,2) = 0

Thanks

Aditya

NAVEEN

• Sep 7th, 2011

 

Code
 

smonroy

 Profile Answers by smonroy 

• Sep 23rd, 2011

 

Hi, I think that this will be the best way to do.

Code
span style="color: #FF0000;">'odd''even''RESULT''odd''even''RESULT'

srikanth.cherukupalli

 Profile Answers by srikanth.cherukupalli 

• Jan 12th, 2012

 

Code
 

ASHOK PANGULURI

• Feb 11th, 2012

 

For even rows:

Code
 

For odd rows:

Code
 

srikanth.cherukupalli

 Profile Answers by srikanth.cherukupalli 

• Feb 29th, 2012

 

select * from emp where(columnname,0) in (select columnname,mod(rownum,2) from emp); for even
select * from emp where(columnname,1) in (select columnname,mod(rownum,2) from emp); for odd

Siva Kumar S

• Mar 2nd, 2012

 

It is a very simple SQL query, follow the code given below

Code
 

sampra

 Profile Answers by sampra 

• Mar 6th, 2012

 

For Even: select * from student where(columnname,0) in (select columnname,mod(rownum,2) from student)
For Odd: select * from student where(columnname,1) in (select columnname,mod(rownum,2) from student)

Anup

• May 23rd, 2012

 

Code
 

venkat

• Jun 27th, 2012

 

Code
 

union all

Code
 

Sabbir

• Aug 17th, 2015

 

What programming language is this? Can you please provide this code in PHP ?