How to get Top 10 Salaries from a Table

Answer Posted / regu

select distinct salary from table name hwre rownum <=10

Is This Answer Correct ?    6 Yes 5 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is bind package and plan in db2?

591


If I have a view which is a join of two or more tables, can this view be updateable?

688


What r the comman abends in db2, jcl and cobol???????

1815


What is db2 purescale?

543


I understand Join always perform better than subqueries. Then what is the advantage/use of Subqueries/correlated subqueries etc.,in DB2 programming.Please explain.

1646






What is rct?

749


Are view updateable?

627


How would the varchar column remarks defined?

633


Explain the benefits you can get from mainframe connect?

520


How and when does the db2 enforces the unique key?

611


What kind of database is db2?

569


What are union and union all?

537


What is difference between isnull and coalesce?

616


How to find the number of rows in a db2 table?

644


What do you mean by cursor?

580