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

Display Odd/ Even number of records?

Question Posted / shareef

3 Answers
6707 Views
I also Faced
E-Mail Answers

Answer Posted / 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 View All Answers

Please Help Members By Posting Answers For Below Questions

How to change user password in oracle?

1093

Explain coalesce function?

1248

Is primary key indexed by default in oracle?

1048

Explain how you would restore a database using RMAN to Point in Time?

2185

How to create lov dynamically at runtime & attach to text field?

1238

What is sharded cluster?

1070

Why oracle is used?

1106

How can we view last record added to a table?

1104

What do you mean by a deadlock?

1107

How to count duplicated values in a column in oracle?

1103

What is a nvl function?

1093

Can we write dml statement in function in oracle?

1124

How to create a new oracle data file?

1074

How do we get field details of a table?

1027

What is max rowid in oracle?

1081