select max(sal) from employees where salary

how to get second highest salary in SQL(as/4000

Question Posted / sachin

Answer Posted / sachin

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

Is This Answer Correct ?

19 Yes

3 No

Please Help Members By Posting Answers For Below Questions

Does oracle roll back the transaction on an error?

963

What is the difference between Union and Union all. Which is faster.

1342

Explain polymorphism in pl/sql.

1059

How to add a column ‘salary’ to a table employee_details?

955

What is serial sql?

919

What is database migration?

916

What is a parameter query?

1023

explain the advantages and disadvantages of stored procedure? : Sql dba

957

What is data definition language?

1048

What is the difference between the repeatable read and serializable isolation levels? : Transact sql

1017

What is where clause in sql?

984

define sql delete statement ? : Sql dba

972

What are schema-level triggers?

1047

What is meant by temporal data?

910

What is difference between stored procedure and trigger?

1061