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

Is id a reserved word in sql?

1156

What is the most important ddl statements in sql are?

1005

What is rank function in sql?

1041

How show all rows in sql?

1020

How to use distinct and count in sql query? Explain

1040

How does a covering index work?

973

Differentiate between syntax and runtime errors.

1199

Is left join faster than join?

1061

Which column in the user.triggers data dictionary view shows that the trigger is a pl/sql trigger?

1041

Can we rollback delete command?

1001

what are different types of keys in sql?

1165

How to select the Nth maximum salary from Table Emp in Oracle SQL Plus ?

1119

What is your daily office routine?

2280

What is set serveroutput on?

1146

What does the file extension accdb stand for?

984