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

How to execute stored procedure in db2 command editor?

1103

What is universal database?

1118

What is plan in cobol db2?

1204

What is an instance in db2?

1084

What do you mean by cursor?

1032

Is db2 a database?

1027

What are bind parameters in db2?

1097

What is db2 bind process?

1292

What is the function of logging in the db2 database?

1172

What is the cobol picture clause of the db2 data types date, time, timestamp?

1123

How do you stop a db2 database in linux?

1058

Is ibm db2 free?

1067

What is with ur in db2?

1384

What is deadlock in db2?

1122

If the cursor is kept open followed the issuing of commit, what is the procedure to leave the cursor that way?

1222