find out the third highest salary?
Answer Posted / asadullahrao
select max(sal) from emp where sal<(select max(sal) from
emp where sal<(select max(sal) from emp))
Is This Answer Correct ? | 1 Yes | 6 No |
Post New Answer View All Answers
15. Display the item_cost and then truncate it to the nearest hundred, ten, unit, tenth and hundredth.
how the indexes are stored in the Oracle Database?
What is blob data type in oracle?
Explain the use of grant option in imp command.
How to convert characters to times in oracle?
What are the most common interview questions on ETL Testing for experience?
hi friends i completed b.com 2004.i have 3y accounting exp. in manufacturing company.now i have completed oracle finance.pls suggest me how will get job in oracle.can i get job in oracle.
Is oracle a language?
Assuming that you are an End User How to find that in the payment Batch some of the Invoice was Missing To pay How to find That??
Give the constructs of a package, function or a procedure.
11. Display the client number and name and the client number and name of the person who referred that client.
How to get maxsal , minsal, ename department wise in single query
How can we find out the duplicate values in an oracle table?
Explain index?
What are a cluster and non-cluster index?