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
How to connect to oracle using service name instead of sid?
How to create additional tablespaces for an new database?
query optmization techniques and quwry analyser+projects+ppts
Why is oracle database so popular?
What are the differences between primary key and unique key?
How many file formats are supported to export data?
How to load data through external tables?
How to find out what oracle odbc drivers are installed?
How to create a testing table in oracle?
What is meant by raw datatype?
How to use "in" parameter properly?
What are the components of logical database structure in oracle database?
how to make an oracle object
How to create an oracle testing table?
How many types of synonyms in Oracle?
