select max(sal) from emp where sal<>(select max(sal) from emp);

Write a query to get 2nd maximum salary in an employee table ?

Question Posted / jebitha

Answer Posted / jebitha

select max(sal) from emp where sal<>(select max(sal) from
emp);

Is This Answer Correct ?

7 Yes

9 No

Please Help Members By Posting Answers For Below Questions

How can get second highest salary in sql?

499

Where is all the data on the internet stored?

547

What is %s in sql?

558

how to shutdown mysql server? : Sql dba

563

What is the difference between a database and a relational database?

558

Is there a 64 bit version of ssms?

508

Is sql a case sensitive language?

508

Is sql procedural language?

548

How many aggregate functions are available there in sql?

523

Why indexing is needed?

509

What is null in pl/sql?

618

what is 'mysqlcheck'? : Sql dba

563

Can we use distinct and group by together?

581

How can you tell the difference between an index and a view?

485

What is pl/sql language case sensitive?

629