select sal from(select ename,sal rownum from emp orderby sal desc group b

How to get Top 10 Salaries from a Table

Question Posted / bharath

Answer Posted / bharath

select sal from(select ename,sal rownum from emp orderby sal
desc group by sal,rownum)where topsal='&nth';

Is This Answer Correct ?

1 Yes

2 No

Please Help Members By Posting Answers For Below Questions

What is explain in db2?

585

What is the syntax for creating a table in the db2 database?

628

What is view db2?

624

What is the maximum size of a char data type in db2?

588

How do I delete a table in database?

599

What is dbrm? What it contains?

682

What is data manager?

610

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

1820

can all users have the privilage to use the sql statement select * (dml)?

642

What are db2 objects?

641

Are views updateable?

645

How to execute stored procedures?

622

before altering a table is it necessary to lock ? if lock what is it ? how to do ? ifi want to lock a table what is that command ?

1714

Define declaration generator (dclgen).

667

What do you mean by rollback?

572