find out the third highest salary?
Answer Posted / neha
select max(sal) from emp where sal <(select max(sal)from emp
where sal<(select max(sal) from emp));
Is This Answer Correct ? | 103 Yes | 31 No |
Post New Answer View All Answers
How to open a cursor variable?
src name sex a,male b,female c,male d,female Required output : male female a,b c,d tried pivot but was not successfull select * from src pivot (max(name) for sex in ('MALE','FEMALE'));
How to turn on or off recycle bin for the session?
How many types of tables are there in oracle?
How to update a table row with a record?
Explain integrity constraint?
How to drop an index in oracle?
What are internal user account in oracle?
is there a tool to trace queries, like profiler for sql server?
What are the limitations of check constraint?
What is BBED in Oracle?
Can multiple columns be used in group by in oracle?
How to shutdown your 10g xe server?
What is meant by raw datatype?
What is recycle bin in Oracle?