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
What is open database communication (odbc) in oracle?
How to pass a cursor variable to a procedure?
what is port in oracle? how is it related to database application.
How do you increase the OS limitation for open files (LINUX and/or Solaris)?
What is integrity and what is constraint??Explain with example
How to count groups returned with the group by clause in oracle?
Can we use bind variables in oracle stored procedure?
How to filter out duplications in the returning rows using oracle?
What do you mean by group by clause?
Which is better Oracle or MS SQL? Why?
Is oracle an open source?
Explain database link?
Explain what does a control file contain?
How data locks are respected in oracle?
Why is oracle used?
