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 the reason behind not using select * in embedded sql programs?

1120

Explain about rct.

1093

what is a corelated subquerry?

1126

What happens in bind step in a db2 program?

978

What are the uses of db2 optimizer?

1299

What is db2 bind process?

1246

Can we insert update delete in view?

975

Can we update view in db2?

1007

What is a bind card?

1225

What is db2 stogroup?

1167

How to find the number of rows in a db2 table?

1120

What is the difference between cursor and select statement?

1114

can we view the access paths created by dbrm ? how ? thx

7104

What is meant by dclgen?

1116

What are bind parameters in db2?

1051