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
SELECT * FROM tablename WHERE MOD (rowindex, 2) = 0; FOR EVEN ROWS


 


SELECT * FROM tablename WHERE MOD (rowindex, 2) = 1; FOR ODD ROWS

smonroy

 Profile Answers by smonroy 

• Sep 23rd, 2011

 

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

Code
SELECT  id_table, (CASE WHEN ABS(id_table) % 2 = 1 


    THEN 'odd' 


    ELSE 'even' 


    END) AS 'RESULT' 


FROM table_name 


 


Example:


SELECT  id_ubication, (CASE WHEN ABS(id_ubication) % 2 = 1 


        THEN 'odd' 


        ELSE 'even' 


    END) AS 'RESULT'


FROM ubication


 


RESULT:


 


id_ubication  RESULT


18                 even


19                 odd


20                 even


 


 

srikanth.cherukupalli

 Profile Answers by srikanth.cherukupalli 

• Jan 12th, 2012

 

Code
SELECT * FROM TABLENAME WHERE MOD(column_choosen_with_integer_values,2) = 0;


FOR even


SELECT * FROM TABLENAME WHERE MOD(column_choosen_with_integer_values,2) != 0;


FOR odd

ASHOK PANGULURI

• Feb 11th, 2012

 

For even rows:

Code
SELECT * FROM emp WHERE mod(rowid,2)=0;

For odd rows:

Code
SELECT * FROM emp WHERE mod(rowid,2)<>0;

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
SELECT R1,employee_id,last_name FROM


(SELECT employee_id,last_name,ROWNUM AS r1


FROM employees)


WHERE MOD(R1,2)=0;


 


 

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
SELECT id, version, authority


FROM (SELECT id, version, authority, rownum row_num FROM OBTWC_ROLE)


WHERE mod(row_num,2) = 0;

venkat

• Jun 27th, 2012

 

Code
SELECT * FROM (SELECT rownum rn,col1,col1 FROM table_name) WHERE mod(rn,2)=0

union all

Code
SELECT * FROM (SELECT rownum rn, col1,col2 FROM table_name) WHERE mod(rn,2)=1;

Sabbir

• Aug 17th, 2015

 

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