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

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

Question Posted / punyaslok

Answer Posted / punyaslok

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

Is This Answer Correct ?

0 Yes

3 No

Please Help Members By Posting Answers For Below Questions

i have a data in my source as a flat files what test i have to perform the next step can any body help to me

2174

how to load dimension table and fact table. plz tell me the steps.

2145

EXL informatica Questions

1447

Explain sql transformation in script mode examples in informatica

1211

what is the -ve test case in your project.

2462

explain one complex mapping with logic? sales project?

6738

Can any one give me a real time example for FACT TABLE & DIMENSIONAL TABLE?

2186

what is the size of u r source(like file or table)?

2310

What are the limitations of joiner transformation?

1181

Differentiate between joiner and lookup transformation?

1161

What are the differences between a connected lookup and unconnected lookup?

1127

Explain the difference between mapping parameter and mapping variable?

1083

wf dont have integration severances how you can run?

1989

What do you mean by DTM and Load manager and what is difference between load manager and load balancer?

1212

Explain what transformation and how many are there in informatica?

1032