Select Min(Salary) from Curtest where Salary in (select Top 2 Salary from

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

Question Posted / sagar

Answer Posted / sagar

Select Min(Salary) from Curtest where Salary
in (select Top 2 Salary from Curtest order by salary desc)

Is This Answer Correct ?

0 Yes

0 No

Please Help Members By Posting Answers For Below Questions

What is range partitioning?

959

What is the difference between the conventional and direct path loads? : aql loader

1391

how to calculate the difference between two dates? : Sql dba

1055

What is equi join in sql?

1066

Which one is better subquery or joins?

1058

Is sql a dbms?

996

what is the difference between join and union? : Sql dba

1106

How do you sort in sql?

1013

How do you update f as m and m as f from the below table testtable?

1848

What is time based sql injection?

955

what are the different tables present in mysql? : Sql dba

980

What is record in pl sql?

1076

Are stored procedures compiled?

915

What is on delete set null?

1084

Is delete faster than truncate?

1002