--TO FIND EVEN NUMBER SELECT * FROM Table WHERE ROWID IN (SELECT DECODE(M

Display Odd/ Even number of records?

Question Posted / swastik mohanty

3 Answers
6442 Views
I also Faced
E-Mail Answers

Answer Posted / 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

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

What is the difference between formal parameters and actual parameters?

1006

What is difference between cartesian join and cross join?

1018

How will you differentiate between varchar & varchar2?

993

Why packages are used in oracle?

1002

What is the difference between online and offline backups?

974

Why use resource manager in Oracle?

1052

What are the types of partitions in oracle?

976

HI, Please let me know the syllabus for Oracle OCA and OCP Certification

2434

How can I combine multiple rows into a comma-delimited list in oracle?

1001

How to declare a local variable?

1055

What is a database schema in oracle?

1055

What is a table in oracle?

928

How do I use unicode codesets with the weblogic jdriver for oracle driver?

1015

What operating systems are supported by oracle database 10g xe?

985

How to change program global area (pga) in oracle?

1034