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
Explain what are synonyms used for?
Explain index?
How to see the table columns used in an index?
What is a snapshot log?
What is procedure overloading in oracle?
How to create a new table by selecting rows from another table?
What is the difference between substr and instr?
How to convert numbers to characters in oracle?
22. Display the order number, number of lines in the order, total number of items and total value for all orders that have a total value greater than $100
material view and view disadvantages?
List the types of joins used in writing subqueries?
How to manage transaction isolation level?
Can u please explain me the Discussion on Except ,using cast like type cast. Question in the context of difference between two tables
Can group functions be used in the order by clause in oracle?
What is a database table in oracle?