select *from emp where max(sal)=dept;

HOW TO DISPLAY MAXIMUM SALARIES FROM EMP DEPARTMENT VISE ALONG
WITH DEPARTMENT NAMES? E.g EMP,DEPT

Question Posted / guest

Answer Posted / guest

Is This Answer Correct ?

2 Yes

16 No

Please Help Members By Posting Answers For Below Questions

What are the various oracle database objects?

1108

What is an external table?

979

How to increment dates by 1 in oracle?

1022

How to view existing locks on the database?

1014

What are the different types of trigger and explain its various uses and functions?

1034

What is an Oracle Instance?

1092

How to retrieve data from an explicit cursor?

1023

Explain overloading. Can functions be overloaded?

948

What will be the syntax to find current date and time in format "yyyy-mm-dd"?

985

How do I manually create a database in oracle?

979

How do I recompile a procedure in oracle?

928

What is a relational database management system?

1087

Which dictionary view(s) would you first look at to understand or get a high-level idea of a given Advanced Replication environment?

1846

What is memory advisor in Oracle?

1042

What is Redo Log Buffer in Oracle?

1155