select last_name,salary from employees where salary = (select max(salary)

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

Question Posted / sanjib b

Answer Posted / sanjib b

select last_name,salary from employees where salary =
(select max(salary) from employees
where salary <> (select max(salary) from employees))

Is This Answer Correct ?

1 Yes

0 No

Please Help Members By Posting Answers For Below Questions

what are the differences between public, private, protected, static, transient, final and volatile? : Sql dba

1094

What is sql key?

1045

What is duration in sql profiler trace?

1140

How to avoid duplicate records in a query?

1055

What is consistency?

1187

What is use of package in pl sql?

1071

Are left and right joins the same?

1161

how to get a list of indexes of an existing table? : Sql dba

1007

What is db journal file?

1157

The in operator may be used if you know the exact value you want to return for at least one of the columns.

1228

Explain unique key in sql.

1063

Explain what is a column in a table?

1161

what are the maximum number of rows that can be constructed by inserting rows directly in value list? : Transact sql

1008

how do you tune the slow running queries in oracle db , explain the methodology

3236

Can we rollback delete command?

1039