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 clone table?

592

What is catalog database in db2?

646

How can you quickly find out the # of rows updated after an update statement?

634

What is cloudant database?

643

How to resolve deadlock issue

17991

Which component is used to execute the sql statements?

623

Describe major components of db2?

642

What is runstats utility in db2?

569

What is multi row fetch in db2?

610

How to restart a DB2 program?

1366

can we view the access paths created by dbrm ? how ? thx

6262

What is meant by explain?

662

What is the latest version of ibm db2?

741

How to test SQL -911 error while developing COB-DB2 program

6720

What is a db2 package?

599