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;

can we use bulk loading when we use look in mapping

1 Answers   TCS,

i have source flat file like 1 a,1 b,1 c,2 a,2 b,2 c i want output as 1 a,b,c and 2 a,b,c ... how can achieve this

5 Answers   TCS,

in my source table i want to delete first and last records and load in between records into target? how can it possible?

3 Answers   HCL, Thomson Reuters,

How do you handle decimal places while importing a flatfile into informatica?

1 Answers  

How will you display "Mr" for male & "Mrs" for female in target table?

7 Answers  

What is source qualifier?

6 Answers   SDS,

Workflow is long running due to long running sql query so when we refer the query plan it tells the issue is due to partition of the db table. How to handle this?

0 Answers  

How to load the source table into flat file target(with columns) in informatica?

4 Answers   Accenture,

Differences between connected and unconnected lookup?

0 Answers  

Write the prerequisite tasks to achieve the session partition?

0 Answers  

What are the different transaction levels available in transaction control transformation?

0 Answers   Informatica,

what is galaxy repository?

2 Answers