select max(salary) from emp where salary

find out the second highest salary?

Question Posted / digvijay

Answer Posted / digvijay

select max(salary) from emp where salary < Top Salary

Is This Answer Correct ?

0 Yes

0 No

Please Help Members By Posting Answers For Below Questions

WHEN CURSOR MOVES FROM ONE FORM TO ANOTHER FORM, HOW MANY TRIGGER WILL BE FIRED AND WHAT ARE THEIR SEQUENCE?

2248

What is merge statement used for?

967

What is an oracle wallet?

880

What are the restrictions in a oracle read only transaction?

966

What are the different editions of oracle?

1047

How to use fetch statement in a loop?

970

is there a tool to trace queries, like profiler for sql server?

1076

How would you begin to troubleshoot an ORA-3113 error?

2022

What is a nested table?

1003

How much memory your 10g xe server is using?

1049

How to best split csv strings in oracle 9i?

983

Explain overloading. Can functions be overloaded?

934

How do you find out from the RMAN catalog if a particular archive log has been backed-up?

2051

List out the types of joins.

1079

Name the various constraints used in oracle?

968