Technical Discussion :: SQL
Home > Freshers > Technical Interview Questions > SQL
5. Write a query to select the second highest salary from a table.
Answer:
SELECT max(salary) AS salary2 FROM orders WHERE salary < (SELECT max(salary) AS salary1 FROM orders)
Asked In :: TCS Accenture Goldman Sachs
SELECT max(salary) AS salary2 FROM orders WHERE salary < (SELECT max(salary) AS salary1 FROM orders)