select max(salary) from employee where salary<(select max(salary) from e

find out the second highest salary?

Question Posted / ishrat ali

Answer Posted / ishrat ali

select max(salary) from employee where salary<(select max(salary) from employee);

Is This Answer Correct ?

1 Yes

0 No

Please Help Members By Posting Answers For Below Questions

What is set verify off in oracle?

1158

How to use subqueries in the from clause in oracle?

1165

What is the dynamic sql in oracle?

1134

How to get execution statistics reports on query statements?

1153

Difference between varchar and varchar2 data types?

1262

Can we store images in oracle database?

1067

How to do clean up if create database failed?

1068

What is sharded cluster?

1070

What are transaction isolation levels supported by oracle?

1116

What is the difference between Delete, Truncate and Drop in Oracle?

1185

What are ddl statements in oracle?

1128

How to create a stored procedure in oracle?

1151

how to handle exceptions in post production

1485

What is Trigger in Oracle?

1241

What is the string concatenation operator in oracle?

1231