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

11 Answers
27631 Views
Accenture, HTC, I also Faced
E-Mail Answers

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

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

What is the use of predicate?

985

What is the role of schema in the db2 database?

1184

Are view updateable?

985

How can you classify the locks in db2?

1035

How do you simulate the explain of an embedded sql statement in spufi/qmf?

1027

What is the syntax for FETCH in DB2 ?

1141

What are the bind parameters ibm db2?

991

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

975

What is db2?

1126

What's The Percentage Free Space ?

1158

can we view the access paths created by dbrm ? how ? thx

6980

Explain how can you do the explain of a dynamic sql statement?

1066

I have a subprogram B calling from mainprogram A.I have opened a cursor in A ,Can i fetch the same cursor in subprogram B , If yes , Please explain the reason?

2340

How can you validate Sql errors during cursor operation in db2 pgms and where do you code?

2170

What is the use of runstats in db2?

1024