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 rownum in sql?

1038

What is trigger explain it?

1011

What does plv msg allows you to do?

1137

Is truncate ddl or dml?

990

What are two statement types in sql?

1086

how do you control the max size of a heap table? : Sql dba

975

How do you optimize a stored procedure query?

996

What is mutating sql table?

1104

What is composite primary key in sql?

993

What is sql comments?

1072

Which tcp/ip port does sql server run?

998

How do you optimize a query?

994

define sql update statement ? : Sql dba

1114

how to enter characters as hex numbers? : Sql dba

1033

How to run sql functions in pl/sql?

1050