select rownum,empno,ename,sal from (select rownum,empno,ename,sal from emp

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

Question Posted / anjan

Answer Posted / anjan

select rownum,empno,ename,sal from (select
rownum,empno,ename,sal from emp)
group by rownum,empno,ename,sal
having rownum in (1,3,5)

Is This Answer Correct ?

1 Yes

0 No

Please Help Members By Posting Answers For Below Questions

What are the new features of informatica 9.x in developer level?

960

whats the logic to load the lower level of granularity of data to fact table.

2237

What is primary and backup node?

1102

hi friends ... i have insurance project(informatica),can you please tell me how many table and mappings we need to use?and explain me.. thank you

9775

How can you increase the performance in joiner transformation?

1164

what is SDLC way of code development?

1998

Can we use procedural logic inside infromatica? If yes how, if now how can we use external procedural logic in informatica?

1001

What is the benefit of session partitioning?

1073

How do you handle two sessions in Informatica

1095

What is the function of aggregator transformation?

1042

What are the types of lookup transformation?

1041

How to generate sequence numbers without using the sequence generator transformation?

1158

How to convert multiple rows to single row (multiple columns) in informatica

1342

Different qualification between a related rotate toward the sky and isolates look upward?

952

What are junk dimensions?

1043