(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

16 Answers
25247 Views
Cap Gemini, IBM, I also Faced
E-Mail Answers

Answer Posted / punyaslok

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

Is This Answer Correct ?

0 Yes

3 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

What is the maplet?

1092

what is the hint? how to use it to reduce the query processing in program?

7774

Explain why we use partitioning the session in informatica?

1072

how many types of dimensions are available in informatica?

1070

can i any one explain me realtime healthcare project explanation..for interview .iam new to informatica .thanks in advance.

3851

differences between service based and product based?

1997

design of staging area?

2016

Explain pushdown optimization $pushdownconfig parameter - informatica

1116

What you know about transaction control transformation?

980

What is the use of source qualifier?

1116

How to load data in informatica ?

990

What are the different lookup cache(s)?

1098

Design a mapping to get the pervious row salary for the current row. If there is no pervious row exists for the current row, then the pervious row salary should be displayed as null.

1276

How can we delete duplicate rows from flat files?

1204

In What Situations we can use MappingParameters ,Mapping Variables AND Session Parameters in REAL TIME.

2047