SELECT * FROM (select * from employee ORDER BY salary desc) employee2 WHE

How to get Top 10 Salaries from a Table

Question Posted / shammi

Answer Posted / shammi

SELECT *
FROM (select * from employee ORDER BY salary desc) employee2
WHERE rownum <= 10
ORDER BY rownum;

correct me if am wrong

Is This Answer Correct ?

3 Yes

1 No

Please Help Members By Posting Answers For Below Questions

How do I create a view in db2?

972

How do we specify index to include or not during bind process.

2069

How to find primary key of a table in db2?

1001

Define declaration generator (dclgen).

1066

How can you validate Sql errors during cursor operation in db2 pgms and where do you code?

2166

How to rename a table in DB2 ?

1029

What is the usage of open cursor command?

1033

Is it possible using max on a char column?

1083

What are packages in db2?

972

What is the difference between cursor stability and repeatable read isolation levels?

1114

What is db2 instance?

1015

What is meant by union and union all?

948

Explain about dbrm.

987

File not opened because library is *PROD and debug is UPDPROD(*NO). ? what may be the reason? how to solve it..?

2864

What is db2 catalog database?

986