select max(salary) from Emp where salary<(select max(salary) from Emp)

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

Question Posted / srinivas

Answer Posted / srinivas

Is This Answer Correct ?

0 Yes

0 No

Please Help Members By Posting Answers For Below Questions

How do you explain an index?

1287

Mention what does the hierarchical profiler does?

1103

What is secondary key?

954

What do you understand by case manipulation functions?

1046

How can you tell the difference between an index and a view?

940

How do sql triggers work?

1056

How can you load multi line records? : aql loader

1089

What is the purpose of using pl/sql?

1157

What are the different ddl commands in sql?

1181

How do I create a memory optimized filegroup?

974

What are the most important ddl statements in sql?

1126

Is coalesce faster than isnull?

976

Which is better stored procedure or query?

965

How do sql databases work?

1010

what is a join? : Sql dba

1047