select max(salary) from employees where salary<(select max(salary) from

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

Question Posted / sushant hole

Answer Posted / sushant hole

select max(salary) from employees where salary<(select max(salary) from
employees);

Is This Answer Correct ?

1 Yes

0 No

Please Help Members By Posting Answers For Below Questions

What trigger means?

1036

Why do we use cursors?

1046

What are the different types of a subquery?

1107

Can we join two tables without common column?

1062

what is offset-fetch filter in tsql? : Transact sql

1000

Define union, minus, union all, intersect ?

1065

What is clustered and nonclustered index in sql?

987

what does the t-sql command ident_current does? : Transact sql

1048

Explain what is an index?

1106

What is fmtonly in sql?

1165

what is the command used to fetch first 5 characters of the string? : Sql dba

1685

Is sql a programming?

1029

What is sqlerrm?

988

Can we insert data into view?

950

Can we write dml inside a function in sql server?

1004