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 is recovery manager in Oracle?
What is an oracle and why it is used?
How to divide query output into groups in oracle?
What are the attributes that are found in a cursor?
How to create an oracle database?
I just want to maintain data like an employee can belongs to 3 or more departments . We can resolve this by using composite key but it avoids normalization rules. So Can anyone tell me how can I maintain data.
Can we connect to ORACLE db using Windows Authentication?
How to select some columns from a table in oracle?
What is the maximum limit on the number of columns in a table?
What is key preserved table?
how to handle exceptions in post production
What is meant by recursive hints in oracle?
Explain about achiever in sql?
What is the difference between pre-select and pre-query?
What is the use of aggregate functions in oracle?