find out the third highest salary?
Answer Posted / daji surwase
select salary
from employees
order by salary desc
offset 2 rows fetch next 1 row only;
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What is the relationship among database, tablespace and data file?
What is a system tablespace and when it is created?
Explain overloading. Can functions be overloaded?
Explain about the analyze command in oracle?
How to create a stored function in oracle?
What is oracle host variable?
Why do I get java.lang.abstractmethoderror when trying to load a blob in the db?
How to use "if" statements on multiple conditions?
How to do clean up if create database failed?
Explain mutating triggers.
What is java oracle used for?
i have a question here... As of my knowledge, when we apply an index (b-tree)on a column, internally it arranges the data in b-tree format and do the fetching process correspondingly... and my quetion is... How a bit-map index arranges the data internally when applied on a column?IS it in b-tree format or whatelse?
How to write date and time literals in oracle?
Explain an exception?
How to create a stored procedure in oracle?