0
How to find the second largest value from a given coloumn
2 Antworten
+ 2
SELECT MAX( col )
FROM table
WHERE col < ( SELECT MAX( col )
FROM table );
Check this thread :
https://www.sololearn.com/Discuss/1616312/how-to-find-second-highest-salary-of-a-given-table-in-oracle-database
+ 1
SELECT TOP(1) col FROM Table ORDER BY col ASC LIMIT 2