find out the third highest salary?
Answer Posted / divya
select min(sal) from salarytbl where sal in(select distinct
top 3 sal from salarytbl order by sal desc)
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
Why do you create or replace procedures rather that drop and recreate.
What is the difference between alert log file and tarce file ?
I have a table called 'test' on source and target with same name, structure and data type but in a different column order. How can you setup replication for this table?
Explain integrity constraints?
How to get execution path reports on query statements?
How to open a cursor variable?
1) Does oracle have any table which contain all the exceptions and it's code internally?
Please explain drop constraint oracle?
What are the various constraints used in oracle?
How to sort output in descending order in oracle?
How do I connect to oracle?
What is an Oracle index?
How do I limit the number of oracle database connections generated by weblogic server?
How would you edit your CRONTAB to schedule the running of /test/test.sh to run every other day at 2PM?
How to define a variable to match a table column data type?