select max(salary) from emoplyee where salary not in(select max(salary) fro

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

Question Posted / prem chhappesh

Answer Posted / prem chhappesh

select max(salary) from emoplyee where salary not in(select max(salary) from employee)

Is This Answer Correct ?

0 Yes

0 No

Please Help Members By Posting Answers For Below Questions

Can we insert in sql function?

1022

How is a PL/SQL code compiled?

1167

Can we use two order by clause in query?

916

What is inner join in sql?

998

Is sql database free?

923

Is there a way to automate sql execution from the command-line, batch job or shell script?

917

What does count (*) mean?

870

Can unique keys be null?

850

How does index help in query performance?

964

Why partition by is used in sql?

963

How do I partition a table in sql?

1037

Can we create foreign key without primary key?

929

What is triggering circuit?

1011

Explain the rollback statement?

961

does sql support programming? : Sql dba

989