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 can the duplicate values be eliminated from db2 select?

1161

How do you select a row using indexes in db2?

1178

What is a Foreign Key?

1142

Explain about rct in db2?

1166

What is the difference between cursor and select statement?

1152

How can you classify the locks in db2?

1135

Why do we need reorg in db2?

1047

What is cursor with hold option in db2?

1138

How is deadlock resolved?

1206

What is page size in db2?

1027

Explain in detail about buffer manager and its functionalities?

1145

What is meant by union and union all?

1055

What are the contents of dclgen?

1164

what is the sqlcode -501

13309

How do I import data from excel to db2?

1130