how to find the second highest salary from emp table?

Answer Posted / hari thorat

select max(salary) from employee where salary <(select max(salary) from employee);

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What are sql commands?

505


how many sql ddl commands are supported by 'mysql'? : Sql dba

531


Is null operator in sql?

610


What is a behavioral trigger?

517


Can we insert in sql function?

551






explain the options of myisamchk to improve the performance of a table. : Sql dba

549


Does pl/sql support create command?

578


Which are the different types of indexes in sql?

563


what is a field in a database ? : Sql dba

547


How to create your own reports in sql developer?

544


What is #table in sql?

523


How to install oracle sql developer?

573


What are the benefits of stored procedures?

538


How can we make an if statement within a select statement?

543


What is difference between pl and sql?

535