select * from emp where sal in (select max(sal) from emp where level<=

a query to select maxmun 3 salaries of employee table

Question Posted / kannan

Answer Posted / kannan

select * from emp
where sal in (select max(sal) from emp
where level<=3
connect by prior sal>sal
group by level)

Is This Answer Correct ?

1 Yes

2 No

Please Help Members By Posting Answers For Below Questions

What is system tablespace?

1147

When system tablespace is created?

1088

What is oracle sid?

999

How can you use check constraints for self referential integrity?

1013

Explain the use of compress option in exp command.

1066

How does one get the view definition of fixed views/tables?

1069

How to start instance with a minimal initialization parameter file?

1083

What is primefaces used for?

1094

Where do you use decode and case statements?

1042

What is dual table oracle?

1027

What is the usage of synonyms?

1210

What privilege is needed for a user to connect to oracle server?

1031

Describe the types of sub query?

1055

Does facebook use oracle?

1079

What is the difference between sharding and partitioning?

1038