When it comes to finding the second highest salary in Oracle SQL, there are multiple approaches that can be used. According to a recent article on Dev.to, three common methods for achieving this include using ROW_NUMBER(), RANK(), and MAX functions. The ROW_NUMBER() method assigns a sequential number to each row ordered by salary in descending order, allowing you to retrieve the second highest salary by selecting the row with rn = 2. The RANK() method is similar, but it assigns the same rank to rows with equal salary values, while the MAX function can be used with a subquery to find the maximum salary that is less than the highest.

Source: https://dev.to/mrcaption49/second-highest-salary-in-oracle-sql-4781