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 tns service name?
What is oracle and what are its different editions?
Explain cascading triggers.
Explain the use of grant option in imp command.
Explain the use of inctype option in exp command.
What is an oracle?
What is a dead lock in oracle?
What are the different types of trigger and explain its various uses and functions?
How do we get field details of a table?
What is set operator oracle?
What is the difference between post-database commit and post-form commit?
What is oracle host variable?
How to define a data source name (dsn) in odbc manager?
Hi this srilatha. I comlpeted my Oracle-hrms. can u provide me interview questions on Core hr, payroll,sshr,OLM etc..
What is meant by joins?
