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

what is meant by urlencode and urldocode? : Sql dba

1178

What are the datatypes available in pl/sql ?

1107

what are the security recommendations while using mysql? : Sql dba

1123

Can we write ddl statements in functions?

1119

What sql does db2 use?

984

What is numeric function sql?

1066

how would concatenate strings in mysql? : Sql dba

1099

What is interval partition?

1060

what is an extent ? : Sql dba

1105

What is exception? What are the types of exceptions?

1073

How do you modify a table in sql?

1129

what does it mean to have quoted_identifier on? What are the implications of having it off? : Sql dba

1007

How to Execute a Package in PL/SQL.?

1210

What are character functions in sql?

943

Why we use pl sql?

963