The query will be like this: Select distinct salary from table order by

How to get Top 10 Salaries from a Table

Question Posted / meena dogra

Answer Posted / meena dogra

The query will be like this:

Select distinct salary from table
order by salary desc
fetch first 10 rows only

Is This Answer Correct ?

31 Yes

5 No

Please Help Members By Posting Answers For Below Questions

What are concurrency issues?

1029

What language is db2 written in?

980

What is isolation level in db2?

941

How do I delete a table in db2?

1006

How many types of page locks can be held in db2?

994

How can tablespace be moved to another dasd volume that is allocated for that tablespace?

1180

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

1219

Is db2 a mainframe?

968

How do I connect my db2 database to ibm?

985

How does coalesce work?

958

What is table space in db2?

959

What is check constraint. Explain with example.

1044

Why cursor is used in db2?

984

Explain in detail about buffer manager and its functionalities?

992

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

2865