find out the second highest salary?
Answer Posted / madan kumar
select *from (select empno,deptno,min(sal) from emp
group by empno,deptno,sal
order by sal desc)
where rownum<=1
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What is an oracle database?
What is a connect identifier?
State some uses of redo log files?
How to calculate date and time differences in oracle?
What is a parameter file in oracle?
How to fetch the row which has the max value for a column?
What is oracle thin client?
What is Trigger in Oracle?
How do I use os authentication with weblogic jdriver for oracle and connection pools?
Name the various constraints used in oracle?
What is the difference between view and materialized view in Oracle?
How to use existing values in update statements using oracle?
What is difference between cartesian join and cross join?
Illustrate how to determine the amount of physical CPUs a Unix Box possesses (LINUX and/or Solaris).
Difference between oracle's plus (+) notation and ansi join notation?