db2 "Select Sal from table_name order by sal desc fetch first 10 rows

How to get Top 10 Salaries from a Table

Question Posted / rajesh

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

Answer Posted / rajesh

db2 "Select Sal from table_name order by sal desc fetch
first 10 rows only with ur"
here i defined an isolation level with ur,so don't be confused.

Is This Answer Correct ?

2 Yes

2 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

My sql statement select avg(salary) from emp yields inaccurate results. Why?

1087

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

7085

What is meant by union and union all?

1007

Explain the function of data manager.

1044

What is explain plan in db2?

983

Why do we bind in db2?

1207

Mention a credible reason why select* is never given preference in an sql program that has been embedded.

1187

Is ibm db2 free?

1003

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

1146

Is db2 relational database?

972

Mention some fields that are a part of sqlca.

1015

What is the maximum No of rows per page?

1065

When do you specify the isolation level?

1027

run jcl for cobol+db2 pgm?.. //jobcard //step001 exec pgm=ikjeft01 //systin dd * DSNSYSTEM(--------) RUN PROGRAM(MYPGMNAME) PLAN(-----), LIB(-------), PARMS(------) /* WHAT WILL U GIVE INSIDE THE BRACKETS... WHAT IS PLAN,PACKAGE,BIND?..PLAN N PACAKGES ARE GENERATED BY ?...

4300

List down the types of triggers in the db2 database?

1022