nth highest value | Varinder Sandhu

Oracle – PL- SQL – Get the Second highest/ largest Value from column

Varinder Sandhu Oracle, Oracle-Tips and Tricks, Varinder Sandhu

How to get the Second highest/ largest Value from the column ? Example: See the table values in the snapshot. As per requirement we need to get second highest/ largest salary form the column sal which is 3000 as per column values. Solution: Script: select ename,sal from ( select ename,

» Read more

nth highest value, nth largest value, Oracle