Computing.Net > Forums > Database > how to find the nth max value

Computer Problems? Computing.Net has over 1,000,000 posts about all things technology related! Over 90% answered within 24 hours! Click here to start participating now! Also, be sure to check out the New User Guide.

how to find the nth max value

Reply to Message Icon

Name: trichyselva
Date: May 31, 2006 at 03:18:51 Pacific
OS: windows xp
CPU/Ram: p4
Product: pentium
Comment:

in oracle what is the query to find the nth max value from a table



Sponsored Link
Ads by Google

Response Number 1
Name: jhunt303
Date: May 31, 2006 at 06:45:01 Pacific
Reply:

SELECT *
FROM (SELECT rownum AS limit,rn.*
FROM

(SELECT * FROM tablename ORDER BY orderfield)

rn)

WHERE limit BETWEEN :n AND :n+1


0
Reply to Message Icon

Related Posts

See More


using Photo Editor to dis... DB2 provider



Post Locked

This post is quite old and has been locked from receiving new replies. Please create a new posting instead.


Go to Database Forum Home


Sponsored links

Ads by Google


Results for: how to find the nth max value

How to find Shell prompt www.computing.net/answers/dbase/how-to-find-shell-prompt/445.html

Need to find Access Templates www.computing.net/answers/dbase/need-to-find-access-templates/399.html

How to Find day for 3 months date using Mod f www.computing.net/answers/dbase/how-to-find-day-for-3-months-date-using-mod-f/644.html