select max(salary) from employee whrere salary<(selsect max(salary) f

find out the second highest salary?

Question Posted / chaitanya pathak

Answer Posted / chaitanya pathak

select max(salary) from employee
whrere salary<(selsect max(salary) from employee)

Is This Answer Correct ?

2 Yes

0 No

Please Help Members By Posting Answers For Below Questions

how to code performance tuning of oracle PL/SQL? can any body send me the perfect answer?

5477

What are the various oracle database objects?

1204

How to drop an index in oracle?

1120

How to convert times to characters in oracle?

1071

Write a trigger example in oracle?

1114

Is oracle an open source?

1127

How to change system global area (sga) in oracle?

1066

How does Oracle guarantee data integrity of data changes?

2457

How to do paging with oracle?

1050

Is there any way to find out when one specific table/view/M-view is used last time. i.e. when one specific object is used in any SELECT statement.

1396

what is the scenario where you take the database to NoArchivelog mode?

2377

What is oracle server autotrace in oracle?

1221

List the various oracle database objects?

1111

What is the difference between a primary key & a unique key?

1140

What is the difference between 10g OEM and 11g OEM?

1016