Answer Posted / 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 |
Post New Answer View All Answers
How to experiment a data lock in oracle?
How to pass a parameter to a cursor in oracle?
What is blob datatype?
In what script is snap$ created? In what script is the scott/tiger schema created?
How to drop an existing view in oracle?
How to rename a tablespace in oracle?
What are the different editions of oracle?
How to pass a cursor variable to a procedure?
Explain parameter file in oracle.
what is the use of triggers in Java program? I mean where do we use triggers in Java programming?
How to return top 5 rows in oracle?
How to create an oracle database?
What is an oracle function?
What is ADDM Advisor in Oracle?
What do you mean by redo log file mirroring?
