In Oracle, select e1.* from emp e1 where &n>(select distinct(COUNT

How to get Top 10 Salaries from a Table

Question Posted / bharath

Answer Posted / bharath

In Oracle,
select e1.* from emp e1
where &n>(select distinct(COUNT(*)) from emp e2
where e1.sal>e2.sal)order by sal;

Place where n=10
we get,

Is This Answer Correct ?

2 Yes

3 No

Please Help Members By Posting Answers For Below Questions

What is a storage group (stogroup)?

1246

is it compulsory commitment control in journal?

2478

What is a plan and package in db2?

1102

What is load utility in db2?

1181

What is temporal table in db2?

1040

What is check constraint in db2?

1087

Define declaration generator (dclgen).

1114

What does reorg do in db2?

1029

Why select is not preferred in embedded sql programs?

1299

How can tablespace be moved to another dasd volume that is allocated for that tablespace?

1240

What is the difference between oracle and db2?

1108

What is catalog database in db2?

1163

Which component is used to execute the sql statements?

1096

Explain dclgen.

1200

What is bind package and plan in db2?

1053