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 maximum size of a char data type in db2?

965

What is the role of schema in the db2 database?

1183

In an sql table that is embedded, what is the procedure to retrieve rows that are part of a db2 table?

1050

What are packages in db2?

972

How do I delete a table in database?

977

What is difference between alias and synonym in db2?

1072

what is the responsibility of the construction superintendent

2081

Why do we bind in db2?

1143

What is the syntax for seeing the columns and data types of a table in the db2 database?

1089

What is null indicator in cobol db2?

994

What is a db2 package?

991

What is cobol db2?

935

What is the difference between db2 and oracle?

1070

What is the physical storage length of the data types date, time, and timestamp?

1042

What is null in db2?

950