select max(salary) from tablename fetch first 10 rows only

How to get Top 10 Salaries from a Table

Question Posted / abirami

Answer Posted / abirami

select max(salary) from tablename
fetch first 10 rows only

Is This Answer Correct ?

4 Yes

25 No

Please Help Members By Posting Answers For Below Questions

What is release/acquire in bind?

1059

Is the primary key a clustered index?

1080

Explain correlated sub-queries.

979

How connect db2 database to datastage?

1190

When reorg is used?

1073

Which command is used to connect to a database in DB2 ? Give the Syntax.

1032

What is db2 purescale?

945

What is a collection in db2?

986

How to take backup of table in db2?

1023

How do I delete a column in db2?

1051

What is the use of runstats in db2?

1024

Which is faster delete or truncate?

1070

How can the duplicate values be eliminated from db2 select?

1044

Mention a credible reason why select* is never given preference in an sql program that has been embedded.

1137

How do I start db2 in windows?

1024