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 sql and mysql?

1181

what are the advantages and disadvantages of cascading style sheets? : Sql dba

1105

How do I tune a sql query?

1043

Can we insert data in view?

1011

What is a full join?

1044

How do you pronounce sql?

1062

How to change sql*plus system settings?

1111

Explain about various levels of constraint.

1000

How can you fetch common records from two tables?

1106

explain the difference between myisam static and myisam dynamic. : Sql dba

992

When do we use triggers?

1149

What is sql data?

1034

How would you reference column values before and after you have inserted and deleted triggers?

1117

What is minus?

1053

How do you modify a table in sql?

1165