|
Hi,
Below is a simple query to find the Nth Maximum / Minimum value of particular column.
Nth Minimum
SELECT * FROM <Table_Name> A
WHERE N = (SELECT COUNT(DISTINCT B.Column_Name ) FROM <Table_Name> B WHERE A.Column_Name >= B.Column_Name)
Where,
N is integer
A & B are alias for the Table
Regards,
Prabhu.T
|