a query to select maxmun 3 salaries of employee table
Answers were Sorted based on User's Feedback
Answer / neo devan
select max(sal) from emp having max(sal)!=(select max(sal)
from emp where max(sal)!=(select max(sal) from emp));
Is This Answer Correct ? | 0 Yes | 4 No |
What is columnar storage what is the advantage?
Can group functions be used in the order by clause in oracle?
What are the different oracle database objects?
what is difference between table and view? where to use views? thanks in advance!
How to write an inner join with the where clause in oracle?
Write a syntax for update query in oracle?
Explain drop constraint oracle?
I have a table called 'test' on source and target with same name, structure and data type but in a different column order. How can you setup replication for this table?
What are main difference between Stored Procedure and Functions.
How to use like conditions in oracle?
How to create id with auto_increment on oracle?
can u send the sql dumps to sivakumarr1987@gmail.com plz help me