select * from (select salary.*,rownum r from salary where sal=(select sal

In a table, 4 person having same salary. How to get Third
person record only?

Question Posted / sanju

Answer Posted / sanju

select * from (select salary.*,rownum r from salary where
sal=(select sal from salary group by sal having count(sal)
=4)) where r=3

Is This Answer Correct ?

1 Yes

0 No

Please Help Members By Posting Answers For Below Questions

What is blocking transformation?

1126

Which is the t/r that builts only single cache memory?

1177

What does role playing dimension mean?

1034

What is decode in informatica?

1123

Informatica settings are available in which file?

976

Explain the types of lookup transformation?

1033

How to implement security measures using repository manager?

1152

What is resilience time?

1109

What are the types of presistent cache in look up tr.

2044

What is the sequence generator transformation in informatica?

1161

Can we create a node as a gateway node and the same node can be assigned to a grid?

1069

Tell me about Propagate functions in informatica

912

What are junk dimensions?

1058

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

2099

Please let me know how to make encryption and decryption with example?

1886