Select max(salary) from salarymaster where salary <(select max(salary)

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

Question Posted / karthik ramasamy

69 Answers
118158 Views
Accenture, BirlaSoft, Letse, Logica CMG, Qwest, Rheal Software, Saagam, Semantic Space, Tailor Solution, TCS, TinyERP, I also Faced
E-Mail Answers

Answer Posted / karthik ramasamy

Select max(salary) from salarymaster where salary <(select
max(salary) from salarymaster)

OR

SELECT MAX(SALARY) FROM SALARYMASTER WHERE SALARY NOT IN
(SELECT MAX(SALARY) FROM SALARYMASTER)

OR

Select max(salary) from salarymaster where salary<(Select
max(salary) from salarymaster)

Is This Answer Correct ?

0 Yes

0 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

Mention what are different methods to trace the pl/sql code?

1201

What is set serveroutput on in pl sql?

1289

What is sql in java?

1074

How can you fetch common records from two tables?

1057

what are dynamic queries in t-sql? : Transact sql

1016

Which is better stored procedure or query?

955

What is the difference between syntax error and runtime error?

1137

What is the difference between the conventional and direct path loads? : aql loader

1391

How can you save or place your msg in a table?

999

Explain the uses of a database trigger?

1037

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

1282

What is pl sql and why it is used for?

1111

What are the datatypes available in pl/sql ?

1098

Can we connect to postgresql using sql developer?

1000

Is join an inner join?

963