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

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

Question Posted / priyank

Answer Posted / priyank

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

Is This Answer Correct ?

1 Yes

0 No

Please Help Members By Posting Answers For Below Questions

What is the difference between SOURCE and TARGET BASED COMMITS? What are the deliverables?in your project?

2083

Explain informatica architecture - version 8 / 9

1046

Which means the first record should come as last record and last record should come as first record and load into the target file?

1041

What is substr in informatica?

1153

When do you use sql override in a lookup transformation?

1045

in u flatfile some of fact records are missed then u load the diminision records are not if u load diminsion records what about fact table records

2203

server hot-ws270 is connect to Repository B. What does it mean?

2481

What do you mean by worklet?

1035

where to store informatica rejected data? How to extract the informatica rejected data?

966

Write the unconnected lookup syntax and how to return more than one column.

1073

Performance tuning in UNIX for informatica mappings?

2527

Can we use the mapping parameters or variables created in one mapping into any other reusable transformation?

1238

What are the settings that you use to configure the joiner transformation?

1021

Reusable transformation and shortcut differences

1800

What is target load order?

1205