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

How to create a new table by selecting rows from another table?

1023

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

962

How do I use unicode codesets with the weblogic jdriver for oracle driver?

1015

How to export data with a field delimiter?

974

What is the difference between alert log file and tarce file ?

2099

What happens in oracle commit?

973

What is proxy method?

931

How can we find out the duplicate values in an oracle table?

997

How to convert characters to times in oracle?

956

What is Redo Log Buffer in Oracle?

1127

Hi this srilatha. I comlpeted my Oracle-hrms. can u provide me interview questions on Core hr, payroll,sshr,OLM etc..

2070

What is coalesce function?

1013

What is a cognitive schema?

910

What is memory advisor in Oracle?

1027

What is oracle database 10g express edition?

1075