Answer / kondeti srinivas

Select * from (select rownum as rn, emp.* from emp) where
rn in (1,3,5);

Answer / suresh

TO DISPLAY THE EVEN NUMBERS
SELECT ROWNUM,EMPNO,ENAME,SAL FROM EMP
GROUP BY ROWNUM,EMPNO,ENAME,SAL
HAVING MOD(ROWNUM,2)=0;


TO DISPLAY THE ODD NUMBER IS TO REPLACE ONLY MOD(ROWNUM,2)!=0

Answer / siva reddy

display odd records
select * from emp where (rowid,1) in ( select
rowid,mod(rownum,2) from emp)

display even records

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

Answer / amedela chandra sekhar

Select * from (select rownum as rno, emp.* from emp) where
rno in (1,2,5);

Answer / amedela chandra sekhar

Select * from (select rownum as rno, emp.* from emp) where
rno in (1,3,5);

Answer / gyana

SELECT RN,EMPNO,ENAME,SAL FROM
(SELECT ROWNUM RN,EMPNO,ENAME,SAL FROM EMP)
WHERE RN IN (1,3,5)

---------------------------------------------------
I ALREADY TESTED ITS WORKING..PLS ANY CORRECTION LET ME KNOW

Answer / sp hari

select * from emp where rowid=(select
decode(mod(rownum,2),0,null,rowid) from emp)

Answer / kondeti srinivas

select * from emp where (rowid,1) in (select rowid,mod(rownum,2) from emp where rownum<=5)

Answer / anjan

select rownum,empno,ename,sal from (select
rownum,empno,ename,sal from emp)
group by rownum,empno,ename,sal
having rownum in (1,3,5)

Answer / uma

select * from (select rownum rn,ename,job,sal
from emp)
where mod(rn,2) <> 0;

How do you remove duplicate records in informatica?

1 Answers  

Explain what is informatica metadata and where is it stored?

0 Answers  

What is a stored procedure transformation?

0 Answers  

Differentiate between router and filter transformation?

0 Answers  

In SCD type 2 if we had select date range. then suppose we had inserted today's date(eq. date is 30 aug 2010) then start date will be today's date(30 aug 2010) what will be the end date,we cant leave it blank?

2 Answers   Cognizant, emc2,

How can a transformation be made reusable?

0 Answers   Informatica,

What is the capacity of power cube?

1 Answers  

yesterday my session run ten min.today its run 30min, wt is the reason? if any issues how to solve that?

2 Answers   iGate,

Explain lookup transformation in informatica

0 Answers   Informatica,

what are the limitation of sorter transformation?

2 Answers   TCS,

Any one tell me some 5 session failure in real time?And why problem occur how to solve the issues?

1 Answers   Amdocs,

what is mean by flag 4 in update strategy t/r

6 Answers