select distinct sal from emp e1 where 3 = (select count(distinct sal) from

Tell me one complex query in oracle ?

Question Posted / prateek

Answer Posted / prateek

select distinct sal from emp e1 where 3 = (select count(distinct sal) from emp e2 where e1.sal <= e2.sal);

Is This Answer Correct ?

0 Yes

0 No

Please Help Members By Posting Answers For Below Questions

What is the use of transformation?

965

what are the Methods For Creating Reusable Transformations?

1119

What are active transformations.

1614

How you prepared reports for OLAP?

1566

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

997

Hi friends I want to know about what r the dimensions in the banking porjects and genarally how many tables r in project ?

1861

What are the mapping parameters and mapping variables?

1115

How an expression transformation differs from aggregator transformation?

1008

what is size of u r database?

2271

What are batches?

1038

Can we create two repositories on same database instance in oracle?

1046

What is a stored procedure transformation?

1011

What are the different types of repositories created using informatica?

1080

How are the sources and targets definitions imported in informatica designer?

1073

scenario where i can use only concurrent execution of workflow.

3095