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 cursor with hold option in db2?

1013

What are union and union all?

920

What is package in db2 mainframe?

923

Is it possible to create an Instance in DB2 using DB2 Control Center ?

1045

Which isolation level provides maximum concurrency?

1093

What is db2?

1126

List out the data types available.

1084

What is the difference between oracle and db2?

1033

What is runstats and reorg in db2?

1242

Is db2 a mainframe?

970

How to run db2 command in windows?

1141

Before you give the explain statement, what are the prerogatives?

970

What is a db2 tablespace?

1002

What is a plan and package in db2?

1048

Can you tell me how can you find out the # of rows updated after an update statement?

1047