How to Select N-th Highest Value From a Table
(Doc ID 272682.1)
Last updated on NOVEMBER 25, 2019
Applies to:
Oracle Database - Enterprise Edition - Version 8.1.7.0 and laterSQL*Plus - Version 8.1.7.0 and later
Oracle Database Cloud Schema Service - Version N/A and later
Oracle Database Exadata Cloud Machine - Version N/A and later
Oracle Cloud Infrastructure - Database Service - Version N/A and later
Information in this document applies to any platform.
Information in this document applies to any platform.
Goal
NOTE: In the images and/or the document content below, the user information and environment data used
represents fictitious data from the Oracle sample or bulit-in schema(s), Public Documentation delivered
with an Oracle database product or other training material. Any similarity to actual environments,
actual persons, living or dead, is purely coincidental and not intended in any manner.
represents fictitious data from the Oracle sample or bulit-in schema(s), Public Documentation delivered
with an Oracle database product or other training material. Any similarity to actual environments,
actual persons, living or dead, is purely coincidental and not intended in any manner.
This document provides the SQL statement which can be used to find the N-th highest or lowest value from a table column of NUMBER datatype. Also, provides the N-th highest or lowest DISTINCT value of a table column.
For example :
- select the 5th highest salary record from the EMP table.
- select the 5th highest salary DISTINCT value from the EMP table.
- select the 5th lowest salary record from the EMP table.
- select the 5th lowest salary DISTINCT value from the EMP table.
Solution
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |
In this Document
| Goal |
| Solution |