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
How to convert csv to table in oracle?
How to drop a tablespace?
What is truncate oracle?
How to test null values?
Why do we use bulk collect in oracle?
What is the difference between a primary key & a unique key?
What is the disadvantage of User defind function?
what is reindexing?
What is a select query statement in oracle?
Difference between varchar and varchar2 data types?
What is Undo Management Advisor in Oracle?
What language does oracle use?
What is oracle analytical function?
Is postgres faster than oracle?
How would you change old and new values in an insert, delete and update triggers?