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 / pramod majhi

Answer Posted / pramod majhi

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

Is This Answer Correct ?

0 Yes

0 No

Please Help Members By Posting Answers For Below Questions

Can we call dml statement in function?

980

What is pl sql architecture?

924

What is synonyms?

1000

What do you mean by “trigger” in sql?

1019

What is primary and foreign key?

1017

What is sql server and ase?

978

What is the difference between inner join and natural join?

956

What is cte sql?

930

What is keys and its types?

1022

What is embedded sql with example?

989

Is stored procedure faster than query?

916

Explain scalar functions in sql?

1019

Why do we need cursor in pl sql?

1080

What is nvarchar in sql?

887

Explain raise_application_error.

1044