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 is view db2?

626

What is a bind in db2?

594

What are sqlcodes –803,-805, -811, -818,-904,-911,-913,-101, +100?

714

Explain packages.

666

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

602

How is a typical db2 batch pgm executed?

642

Hi, i would like to start a new carrier in DB2 DBA.Which and what all step should i have to take..?

2688

Can there be more than one cursor open for any program?

662

What is the role of the data page in the db2 database?

589

What do you mean by cursor?

586

Define db2 and its databases?

621

Can we update view in db2?

562

What is syscat in db2?

580

What is a page in db2?

611

When do you specify the isolation level?

609