SELECT * FROM (select * from employee ORDER BY salary desc) employee2 WHE

How to get Top 10 Salaries from a Table

Question Posted / shammi

Answer Posted / shammi

SELECT *
FROM (select * from employee ORDER BY salary desc) employee2
WHERE rownum <= 10
ORDER BY rownum;

correct me if am wrong

Is This Answer Correct ?

3 Yes

1 No

Please Help Members By Posting Answers For Below Questions

What is bind plan?

1059

What is cursor stability in db2?

1363

How to restart a DB2 program?

1912

What are union and union all?

991

For a db2 column that is being defined as decimal (11, 2), discuss the cobol picture clause.

1113

How to resolve deadlock issue

20158

what is db2 restart?

2166

What are bind parameters in db2?

1052

What is buffer pool?

1111

what is the role of the cursor in db2?

1071

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

1174

Define buffer pool.

1065

If I have a view which is a join of two or more tables, can this view be updateable?

1139

How connect db2 database to datastage?

1249

What are the bind parameters ibm db2?

1058