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 do you mean by storage group (stogroup)?

583

Explain about rct.

652

Is db2 relational database?

572

How will you return the number of records in table?

516

Explain about mirror activator disk mirroring?

560

What is the physical storage length of time data type?

673

What is package in db2 mainframe?

559

What is db2 look?

578

Comment whether the cursor is closed during commit or not.

674

What is view db2?

624

What is dpf in db2?

666

What os does db2 run on?

572

What are db2 objects?

641

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

618

Define db2 and its databases?

620