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 use insert statement in function?

997

what is acid property in database? : Sql dba

1026

How do I create a sql database?

994

What are tables and fields?

1029

what is innodb? : Sql dba

1097

What is count * in sql?

993

What type of database is sql?

1021

How do I start pl sql?

944

What is difference between inner join and cross join?

965

Is natural join and inner join same?

920

What is database migration?

963

Explain the difference between 'between' & 'and' operators in sql

996

How many triggers can be applied on a table?

930

What are tables in sql?

1060

What is index example?

1004