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 to get last monday of a month?

2 Answers   Multifonds,

---

What is the function of Optimizer ?

1 Answers  

---

How to create a server parameter file?

0 Answers  

---

What is a dead lock in oracle?

0 Answers  

---

What are the various types of snapshots ?

0 Answers  

---

What are the types of Database Links ?

2 Answers  

---

what is null value?

11 Answers   KITS, Oracle,

---

What is blob datatype?

0 Answers  

---

a query to select maxmun 3 salaries of employee table

12 Answers   IBM, Polaris,

---

how to find count rows in table without count function?

3 Answers   Oracle,

---

what is difference between cartesian join & cross join even they give same result?

4 Answers   Bank Of America,

---

What is a recycle bin in oracle?

1 Answers  

---