find out the third highest salary?
Answer Posted / kss
Hi every one,
i know that we can get that thr above quer..
one can try using analytic function giving ranks to the
salary column
select sal,dense_rank() over(order by sal desc) rank from
emp
| Is This Answer Correct ? | 18 Yes | 15 No |
Post New Answer View All Answers
What is materialized view in Oracle?
What are the different types of partitions in oracle?
Explain do view contain data?
How to drop an existing view in oracle?
How to convert a string to a date in oracle database?
What are the extensions used by oracle reports?
Explain an exception?
Calculate difference between 2 date / times in oracle sql?
Differentiate between post-database commit and post-form commit?
How to turn on or off recycle bin for the session?
What is blob data type in oracle?
Oracle
What is Virtual Private Database in Oracle?
How to shutdown your 10g xe server from command line?
How to create a new tablespace in oracle?