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

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

Please Help Members By Posting Answers For Below Questions

How does coalesce work?

956

What do you mean by storage group (stogroup)?

983

Is it possible to alter a table – for example adding a column, when another user is accessing or updating some columns?

1028

What is dpf in db2?

1047

Explain db2.

988

What is db2 catalog database?

982

What is reorg and runstats in db2?

1142

Which are the db2 tools to protect integrity of the database?

1068

What is meant by union and union all?

948

What is null in db2?

947

What is sqlca’s maximum length?

1097

What is the syntax for FETCH in DB2 ?

1136

What is rct?

1159

What is ibm db2 database?

949

How can you classify the locks in db2?

1030