select(max(salary) from employee where sal>max salary&salary<ma

Anybody can tell me, how do we find second largest emp
salary from emp table.. Thanks in advance ...

Question Posted / keerthi

Answer Posted / keerthi

select(max(salary)
from employee
where sal>max salary&salary<max salary-1;
if you say no to my answer plz correct me.

Is This Answer Correct ?

0 Yes

0 No

Please Help Members By Posting Answers For Below Questions

How to create an initialization parameter file?

1054

Explain parameter file in oracle.

1030

How to write date and time literals in oracle?

1002

How to delete multiple rows from a table in oracle?

1060

What is execute immediate in oracle?

1021

How to define an anonymous block?

1158

What is Virtual Private Database in Oracle?

1091

What are the different types of failures that occur in Oracle database?

1067

Explain index?

1262

What are the original export and import utilities?

1172

How to filter out duplications in the returning rows using oracle?

1018

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

2103

What is oracle thin client?

1023

Explain the use of inctype option in exp command.

1034

How do I find my oracle client driver version?

1040