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

How do you create a db file?

1021

What are the different dcl commands in sql?

1185

Advantages and disadvantages of stored procedure?

1126

Should I use mbr or gpt?

1033

How to rename a column in the output of sql query?

1074

Is keyword pl sql?

1012

What is hibernate and its relation to sql?

1131

define sql update statement ? : Sql dba

1127

What are the different set operators available in sql?

1033

what is the difference between char_length and length? : Sql dba

1053

Can you rollback after commit?

996

Does sql between include endpoints?

1019

What is the use of non clustered index?

999

What is the use of & in pl sql?

1052

Explain normalization and what are the advantages of it?

959