Display Odd/ Even number of records?

Question Posted / nishi

3 Answers
5379 Views
I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

Display Odd/ Even number of records?..

Answer / nishi

Select rownum,empno,ename,salary from emp group by rownum,empno,ename,salary having Mod(rownum,2)=0 -- To display EVEN records.

Select rownum,empno,ename,salary from emp group by rownum,empno,ename,salary having Mod(rownum,2)=1 -- To display ODD records.

Is This Answer Correct ?

4 Yes

0 No

Display Odd/ Even number of records?..

Answer / swastik mohanty

--TO FIND EVEN NUMBER
SELECT * FROM Table
WHERE ROWID IN (SELECT DECODE(MOD(ROWNUM, 2), 0, ROWID, NULL) FROM Table);
--TO FIND ODD NUMBER
SELECT * FROM Table
WHERE ROWID IN (SELECT DECODE(MOD(ROWID, 2), 1, ROWID, NULL) FROM Table);

Is This Answer Correct ?

2 Yes

0 No

Display Odd/ Even number of records?..

Answer / shareef

select * from emp where (rowid,0) in(select rowid,mod(rownum,2) from emp);---even

select * from emp where (rowid,1) in(select rowid,mod(rownum,2) from emp);---odd

Is This Answer Correct ?

2 Yes

0 No

Post New Answer