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

Mention the downsides of page level lock.

1220

Which isolation level provides highest data integrity?

1190

What is explain in db2?

1080

Is it possible to create an Instance in DB2 using DB2 Control Center ?

1155

List down the data types in the db2 database.

1186

What is the function of logging in the db2 database?

1174

What is runstats utility in db2?

1071

What is buffer pool in the db2 database?

1159

What type of database is db2?

1019

What is the difference between "db2ilist" and "db2 get instance" commands in DB2 Database Server?

1315

What are the uses of db2 optimizer?

1361

For a db2 column that is being defined as decimal (11, 2), discuss the cobol picture clause.

1165

What happens in bind step in a db2 program?

1012

How to view db2 table structure?

1067

what is a corelated subquerry?

1171