if u r using PL/SQL select distinct id from subs

How to get Top 10 Salaries from a Table

Question Posted / shaikshavali

Answer Posted / shaikshavali

if u r using PL/SQL

select distinct id from subs_contacts
where rownum<=10
order by id desc

Is This Answer Correct ?

2 Yes

1 No

Please Help Members By Posting Answers For Below Questions

How do you pull up a query which was previously saved in qmf?

1206

What is bind in db2?

1098

What is the use of with ur in db2?

1110

What is check constraint. Explain with example.

1163

How can the duplicate values be eliminated from db2 select?

1161

What is view db2?

1133

List out the data types available.

1206

What is concurrency?

1306

What is dbrm? When it will be created?

1090

What is a db2 collection?

1110

Define data page.

1133

Why do we bind in db2?

1275

What does db2 plan contain?

1089

can all users have the privilage to use the sql statement select * (dml)?

1224

How do I delete a table in db2?

1126