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
Explain cascading triggers.
How to define a variable of a specific record type?
What is a dead lock in oracle?
What are the different types of modules in oracle forms?
How can we force the database to use the user specified rollback segment?
does the query needs a hint to access a materialized view?
How will you write a query to get a 5th rank student from a table student_report?
What are the arithmetic operations?
When do I need to use a semicolon vs a slash in oracle sql?
When do you get a .pll extension in oracle?
What is literal?
Can we create trigger on materialized view in oracle?
What is the relationship among database, tablespace and data file?
What is recycle bin in Oracle?
Hi friends can u send the oracle 9i full version download link?????????????? please reply ?