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

how will u get 1 and 3rd and 5th records in table what is
the query in oracle please help me

Question Posted / jhansi

Answer Posted / jhansi

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

Is This Answer Correct ?

0 Yes

2 No

Please Help Members By Posting Answers For Below Questions

EXL informatica Questions

1394

How might one distinguish in the case of mapping is right or not without associating session?

1129

What is persistent lookup cache?

1035

What is exclusive and normal mode for repository services?

1147

What do you mean by channel change?

1051

Dimension Object created in Oracle can be imported in Designer Cubes contain measures

2400

What is a predefined event?

1095

What is meant by target load plan?

974

can we override a native sql query within informatica? Where do we do it? How do we do it?

1055

State the limitations where we cannot use joiner in the mapping pipeline?

1068

Do you find any difficulty while working with flat files as source and target?

1099

What all join we can perform in LOOKUP transformation?

981

difference between informatica 8.1.1 and 8.6

3677

Please let me know how to make Data masking in informatica..

1729

Where are the source flat files kept before running the session?

1084