HOW TO DISPLAY MAXIMUM SALARIES FROM EMP DEPARTMENT VISE ALONG
WITH DEPARTMENT NAMES? E.g EMP,DEPT
Answer Posted / guest
select *from emp where max(sal)=dept;
| Is This Answer Correct ? | 2 Yes | 16 No |
Post New Answer View All Answers
What are the various oracle database objects?
What is an external table?
How to increment dates by 1 in oracle?
How to view existing locks on the database?
What are the different types of trigger and explain its various uses and functions?
What is an Oracle Instance?
How to retrieve data from an explicit cursor?
Explain overloading. Can functions be overloaded?
What will be the syntax to find current date and time in format "yyyy-mm-dd"?
How do I manually create a database in oracle?
How do I recompile a procedure in oracle?
What is a relational database management system?
Which dictionary view(s) would you first look at to understand or get a high-level idea of a given Advanced Replication environment?
What is memory advisor in Oracle?
What is Redo Log Buffer in Oracle?