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

What are different types of tables in sql?

993

Why sql query is slow?

985

what are the disadvantages of mysql? : Sql dba

1144

How long will it take to learn pl sql?

932

What is rank dense_rank and partition in sql?

1023

How many aggregate functions are available there in sql?

979

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

1093

Is sql between inclusive?

1118

Is join and inner join the same?

1000

How many unique keys can a table have?

1009

What is a data definition language?

1101

What are the parameter modes supported by pl/sql?

1097

What is mutating error in pl sql?

1013

What is synchronized subquery?

1161

What is sql profiling in oracle?

1056