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 is pl sql commands?

1098

How do sql triggers work?

1096

Are there any features that are decommissioned in 11g that are not present in 11g?

2197

Can we create view in stored procedure?

1026

What is mutating table error?

1240

What is the difference between sql and t sql?

1107

Which is the correct statement about truncate and delete?

1172

What is a composite primary key?

1143

What is difference between nchar and nvarchar?

1103

How to write pl sql program in mysql command prompt?

1165

What is oracle and pl sql?

1160

How to prepare for oracle pl sql certification?

1109

Explain how exception handling is done in advance pl/sql?

1047

List the different type of joins?

1113

Explain what is a column in a table?

1161