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

Hey I am net to informatica? Can any one explain me step by step How scd will work ?

1 Answers   Infosys,

how DTM buffer size and buffer block size are related

3 Answers   Wipro,

What is power play plug in?

2 Answers  

What is the difference b/w natural key and surrogate key

1 Answers  

Can I create one wrkflw which will run different wrkflws on schedule time?

3 Answers  

What are the types of maping wizards that r to be provided in Informatica?

2 Answers  

How can we join the tables if they don't have primary and foreign key relationship and no matching port?

7 Answers  

I have been working in Informix-4gl for the past 2 years in an MNC company.But I'm interested to work in Business Intelligence tools. Is it possible to change the technology now? I'm really confused, please help me

1 Answers  

Explain what is informatica metadata and where is it stored?

0 Answers  

what is dimension table?

17 Answers  

How might you approve all mappings in the archive all the while?

0 Answers  

how the data will be loaded while desiging the schema?which one first (for e.g.-dimesions and facts)

2 Answers   Sonata,