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

What is the purpose of using commit?

1090

What are iseries servers?

1071

What is the difference between plan and package in db2?

1106

What is ibm db2 connect?

984

How to run db2 command in windows?

1189

What is ibm db2 client?

934

How to check table size in db2 sap?

1034

How to get the ddl of a table in db2?

1127

Define db2.

1104

Explain the function of data manager.

1042

What are union and union all?

976

How do I delete a column in db2?

1105

How will you return the number of records in table?

932

What are the rules for db2 programming?

1081

Explain the function done by data manager?

1273