a query to select maxmun 3 salaries of employee table
Answer Posted / 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 |
Post New Answer View All Answers
What is oracle open database communication (odbc)?
How to increment dates by 1 in oracle?
How to use "while" statements in oracle?
what is port in oracle? how is it related to database application.
Is it possible to insert comments into sql statements return in the data model editor ?
Is oracle an operator?
State any two functions of oracle?
Which dictionary tables and/or views would you look at to diagnose a locking issue?
How would you begin to troubleshoot an ORA-3113 error?
What is the usage of merge statement?
What are the different types of trigger and explain its various uses and functions?
How to lock and unlock a user account in oracle?
How do I spool to a csv formatted file using sqlplus?
What do you mean by group by clause?
hello friends Im doing my final year engineering in B.Tech.. one of uncle said he can provide job in his company if im good in database management. but i have only basic knowledge about database, so like to join database management course in good intuition. so friends kindly help me to get good intuition because its my future.