Sql query to get max 5 values

•

What is DaniWeb IT Discussion Community?

You're currently browsing the Oracle section within the Web Development category of DaniWeb, a massive community of 391,705 software developers, web developers, Internet marketers, and tech gurus who are all enthusiastic about making contacts, networking, and learning from each other. In fact, there are 3,241 IT professionals currently interacting right now! Registration is free, only takes a minute and lets you enjoy all of the interactive features of the site.

Join our community!

Please support our Oracle advertiser:

Thread Tools Display Modes

Views: 1758 | Replies: 4 | Solved

•

Join Date: Feb 2008

Location: India

Posts: 5

Reputation: iceman29 is an unknown quantity at this point

Rep Power: 0

Solved Threads: 1

iceman29

Offline

Newbie Poster

Sql query to get max 5 values

Jun 5th, 2008

Hi ,

Can we have an sql query to get the max 5 values from a column?
Please paste a sample code if its possible.

Thanks in advance.

Learn to appreciate and appreciate to learn.

•

Join Date: Feb 2008

Location: India

Posts: 5

Reputation: iceman29 is an unknown quantity at this point

Rep Power: 0

Solved Threads: 1

iceman29

Offline

Newbie Poster

Re: Sql query to get max 5 values

Jun 5th, 2008

Got the soln, as below

 Help with Code Tags 
 sql Syntax (Toggle Plain Text) 
SELECT * FROM (SELECT a FROM <tbl> ORDER BY a DESC) WHERE rownum<=5;
select * from (select a from <tbl> order by a DESC) where rownum<=5;

Thanks.

Last edited by peter_budo : Jul 13th, 2008 at 3:44 am. Reason: Keep It Organized - please use [code] tags

Learn to appreciate and appreciate to learn.

•

Join Date: Jun 2008

Posts: 6

Reputation: sqlstarz is an unknown quantity at this point

Rep Power: 0

Solved Threads: 0

sqlstarz

Offline

Newbie Poster

Re: Sql query to get max 5 values

Jul 4th, 2008

 Help with Code Tags 
 sql Syntax (Toggle Plain Text) 
SELECT * FROM <tab> WHERE rownum <=5
ORDER BY <a> DESC.
select * from <tab> where rownum <=5
order by <a> desc.

I dont think extra subquery is needed here.
pls correct me if m wrong.

Last edited by peter_budo : Jul 13th, 2008 at 3:45 am. Reason: Keep It Organized - please use [code] tags

•

Join Date: Feb 2008

Location: India

Posts: 5

Reputation: iceman29 is an unknown quantity at this point

Rep Power: 0

Solved Threads: 1

iceman29

Offline

Newbie Poster

Re: Sql query to get max 5 values

Jul 12th, 2008

Yes buddy, the extra sub querry is needed, as in below case :

 Help with Code Tags 
 sql Syntax (Toggle Plain Text) 
SELECT * FROM <tab> WHERE rownum <=5
ORDER BY <a> DESC
select * from <tab> where rownum <=5
order by <a> desc

the first 5 rown are getting sorted and then ordered, which would not essesntaily return max 5 values.

However if we use it as :

 Help with Code Tags 
 sql Syntax (Toggle Plain Text) 
SELECT * FROM (SELECT a FROM <tbl> ORDER BY a DESC) WHERE rownum<=5;
select * from (select a from <tbl> order by a DESC) where rownum<=5;