How to Find Nth Highest Salary in SQL - Shiksha Online

How to Find the Second Highest Salary in SQL

💡 SQL Interview Question: 👉 How do you find the Nth Highest Salary in a table? (Super important for SQL Backend Java interviews!) Here’s the clean SQL query 👇 ✅ Using LIMIT (MySQL) SELECT DISTINCT salary FROM employees ORDER BY salary DESC LIMIT N-1, 1; ✅ Using OFFSET (PostgreSQL / SQL Server) SELECT DISTINCT salary FROM employees ORDER BY salary DESC OFFSET N-1 ROWS FETCH NEXT 1 ROW ONLY; ✅ Using Subquery (Works in All Databases) SELECT salary FROM employees e1 WHERE N-1 = ( SELECT COUNT(DIS

SQL Worksheet and run your first query - Oracle Database Video Tutorial | LinkedIn Learning, formerly Lynda.com

Writing SQL Statements | Learn Oracle | Oracle Training and Certification