Select min(sal) from emp where sal in ( select top 3 sal from emp order

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

Question Posted / google

Answer Posted / google

Select min(sal) from emp where sal in (
select top 3 sal from emp
order by sal desc )

Is This Answer Correct ?

0 Yes

0 No

Please Help Members By Posting Answers For Below Questions

What is the difference between a query and a report?

524

What is online transaction processing (oltp)?

605

Explain the methods used to protect source code of pl/sql.

548

What is sql scripting?

563

Is sql dba a good career? : SQL DBA

539

what is the syntax used for partition in tsql? : Transact sql

543

Can you upgrade sql express to full sql?

520

Can primary key be changed?

529

Is sql a backend language?

628

What is exception? What are the types of exceptions?

558

describe mysql connection using mysql binary. : Sql dba

555

What are the popular database management systems in the it industry?

571

What is a relationship and what are they?

582

What is a schema sql?

533

Does truncate remove indexes?

564