(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

Explain informatica architecture - version 8 / 9

1092

What is the scenario which compels informatica server to reject files?

1071

can anyone explain me about retail domain project in informatica?

7948

difference between repository database and repository service?

1152

Explain pushdown optimization $pushdownconfig parameter - informatica

1147

if we have a delimiters at unwanted places in a flat file how can we over come those.

2049

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

2094

What is the status code in stored procedure transformation?

1182

What are batches?

1101

Hello, Can you please send the admin and advanced mapping design sample questions to ns_sharmin@yahoo.com?

2342

Can you generate sequence numbers without using the sequence generator transformation?

1123

What is union transformation?

965

What is a standalone command task?

1205

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

1098

How can we use batches?

1025