Answer / 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.

Answer / swastik mohanty

--TO FIND EVEN NUMBER
SELECT * FROM Table
WHERE ROWID IN (SELECT DECODE(MOD(ROWNUM, 2), 0, ROWID, NULL) FROM Table);
--TO FIND ODD NUMBER
SELECT * FROM Table
WHERE ROWID IN (SELECT DECODE(MOD(ROWID, 2), 1, ROWID, NULL) FROM Table);

Answer / shareef

select * from emp where (rowid,0) in(select rowid,mod(rownum,2) from emp);---even


select * from emp where (rowid,1) in(select rowid,mod(rownum,2) from emp);---odd

How a database is related to tablespaces?

0 Answers  

---

What is a deadlock in SQL? How can you prevent it?

1 Answers  

---

Why use resource manager in Oracle?

0 Answers   MCN Solutions,

---

How many types of tables are there in oracle?

0 Answers  

---

does the query needs a hint to access a materialized view?

0 Answers  

---

what are the disadvantages of hierarchial database over RDBMS?

1 Answers   TCS,

---

How many memory layers are in the oracle shared pool?

0 Answers  

---

SELECT * FROM (SELECT TITLE FROM MOVIE ORDER BY RANK DESC) WHERE ROWNUM > 4; when i run the above query .it produces output as NO ROWS SELECTED.why ?plz any one help me

6 Answers   TCS,

---

What are the values that can be specified for OPTIMIZER_GOAL parameter of the ALTER SESSION Command ?

1 Answers  

---

How many objectname will be created for a single table drop function? Why 'flashback' query giving error "ORA-38312: original name is used by an existing object" while getting the table?

0 Answers  

---

Is insert autocommit in oracle?

0 Answers  

---

What is save point in oracle database?

0 Answers  

---