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

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



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How to convert csv to table in oracle?

528


How to drop a tablespace?

574


What is truncate oracle?

531


How to test null values?

678


Why do we use bulk collect in oracle?

571






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

590


What is the disadvantage of User defind function?

1833


what is reindexing?

1179


What is a select query statement in oracle?

545


Difference between varchar and varchar2 data types?

666


What is Undo Management Advisor in Oracle?

613


What language does oracle use?

598


What is oracle analytical function?

526


Is postgres faster than oracle?

561


How would you change old and new values in an insert, delete and update triggers?

543