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

What is commit in db2?

1061

What is difference between alias and synonym in db2?

1146

How do I add a column to a table in db2?

1105

What is the difference between dbm cfg and db cfg file in db2 ?

1540

What are db2 objects?

1052

How to create backup table in db2?

1096

What is database manager in db2?

1026

Explain dclgen.

1214

What are iseries servers?

1079

What is the syntax for seeing the columns and data types of a table in the db2 database?

1171

What is a Foreign Key?

1102

How to execute stored procedures?

1134

What is the maximum size of varchar data type in db2?

1137

Hi, i would like to start a new carrier in DB2 DBA.Which and what all step should i have to take..?

3157

How do I start db2 in windows?

1104