how to find the second highest salary from emp table?

Answer Posted / shivdas suryawanshi

select salary from emp where salary=(select max(salary)
from emp where salary < (selct max(salary) from emp));

Is This Answer Correct ?    0 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is blind sql injection?

578


What is cursor in pl sql with examples?

481


Is primary key is clustered index?

531


How many types of privileges are available in sql?

739


How bulk collect improves performance?

573






What is the life of an sql statement?

527


Can you call pl/sql package functions from within a fast formula?

565


How does left join work in sql?

521


What are sql commands?

505


What is hibernate and its relation to sql?

594


How to install oracle sql developer?

571


What is faster join or subquery?

512


Does sql use python?

564


What is cursor and its types?

561


What is rowid in sql?

512