find out the third highest salary?
Answer Posted / sabapathi
select sal from employee
where sal=(select min(sal) from employee
where sal>(select min(sal) from employee
where sal>(select min(sal) from employee)))
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
Differentiate between translate and replace?
What is the Tune Query
How to convert characters to numbers in oracle?
Are truncate and delete commands same? If so why?
Explain what are the advantages of views?
What is the sql query to concatenate column values from multiple rows in oracle?
What happens if variable names collide with table/column names?
What is a tns service name?
What is the difference between truncate & delete command?
Where is the export dump file located?
What is java oracle used for?
We are using Oracle apps with XML publisher.In that,we are facing some problems while giving a Footer in RTF Template.While giving a footer in RTF Template it is Visible in all the pages,but after the PDF is getiing generated,the Footer are Visible on alternate pages only (like on first page ,third page) and so on. Please provide the Solution for getting the Footer on all the pages.
Why is oracle database so popular?
How to define a procedure inside another procedure?
What is a sub query and what are the different types of subqueries?