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
Are truncate and delete commands same? If so why?
Where are the settings stored for each instance in oracle?
What is the disadvantage of User defind function?
How to assign data of the deleted row to variables?
How to convert characters to times in oracle?
 What are the oracle DML commands possible through an update strategy?
Explain the use of file option in exp command.
How to drop a stored function?
How to recover a dropped table in oracle?
What privilege is needed for a user to create views in oracle?
What is an oracle recycle bin?
What is recycle bin in Oracle?
What do you understand by a database object? Can you list a few of them?
What is a directory object?
How to declare a local variable?
