Answer / sandipana

select rownum as rank,emp_id,sal from(select
lastname,salary from employees orderby salary desc)
where rownum IN(1,3,5);

Answer / priyank

select * from (select rownum rn,emp.* from emp) where mod
(rn,2)=1;

Answer / millar

ie.

select column from table_name where mod(primary_key_column,2)=1;


select employee_id from employees where mod(employee_id,2)=1

Answer / jhansi

It displays odd rows
select * from emp where (rowid,0) in(select rowid,mod
(rownum,2) from emp);

Answer / punyaslok

(select * from emp)-(select rownum,emp.* from emp order by
mod(rownum,2);

Answer / udaya

SELECT * FROM TABLE_NAME WHERE ROWNUM=1 AND ROWNUM=3 AND
ROENUM=5

Is stop and abort are same in informatica?

0 Answers  

what is incremental loading ?

12 Answers   CTS, IBM, Oracle, TCS,

Difference between task flow and linear task flow

0 Answers  

How could we generate the sequence of key values without using sequence generator transformation in the target ??

12 Answers   TCS, Tech Mahindra,

How many input parameters can exist in an unconnected lookup?

0 Answers  

What are the differences between source qualifier and joiner transformation?

0 Answers  

what are cost based and rule based approaches and what is the difference?

1 Answers  

What is galaxy shema

2 Answers   CGI,

Explain how to import oracle sequence into informatica?

0 Answers  

What is power center repository?

1 Answers  

Can you generate reports in Informatcia?

1 Answers  

What is synonym?

2 Answers   Patni,