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

i want to maintain uniqueness on pdf without make lf??????????

2153

What is clone table?

1037

What is the maximum size of a char data type in db2?

1010

Define db2.

1105

What is the maximum length of sqlca?

1521

Define declaration generator (dclgen).

1111

Where can you declare a cursor in a cobol-db2 program?

1070

Is db2 relational database?

972

What is package in db2 mainframe?

984

What is a bind card?

1216

What do you mean by between and in? Is between inclusive of specified range values?

1089

what is db2 restart?

2149

Why do we need reorg in db2?

984

What is db2 command?

1031

Explain the contention situations caused by locks?

1069