select max(sal) from emp ((select sal from emp)-(select max (sal) from emp

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

Question Posted / varun

Answer Posted / varun

select max(sal) from emp ((select sal from emp)-(select max
(sal) from emp))

Is This Answer Correct ?

5 Yes

8 No

Please Help Members By Posting Answers For Below Questions

What is memory optimized?

1076

Can a varchar be a primary key?

1007

Explain the advantages and disadvantages of stored procedure?

1140

How can we implement rollback or commit statement in a trigger?

1029

What is an inner join sql?

1022

Can we use pl sql in mysql?

1009

Why procedure is used in sql?

1032

Is it possible to create the following trigger: before or after update trigger for each row?

1280

What is execute immediate?

1078

How many postgresql users are there, worldwide?

1057

How can a pl sql block be executed?

944

Can we write dml inside a function in sql server?

941

Explain about various levels of constraint.

939

Why left join is used in sql?

974

What are the benefits of stored procedures?

1058