Interested to Buy Any Domain ? << Click Here >> for more details...
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 the scope of a local variable?
What is set verify off in oracle?
What are the restrictions on external table columns?
How to sort output in descending order in oracle?
How to use in conditions in oracle?
What are named parameters?
What is sequence?
Is truncate autocommit in oracle?
Explain the use of owner option in exp command.
Point out the difference between user tables and data dictionary?
What is bulk collect in oracle?
Compare and contrast between sql and sql server and explain its various functions?
How to insert multiple rows with one insert statement in oracle?
What types of joins are used in writing subqueries?
What are transaction isolation levels supported by oracle?
