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 the is the diff between local index and global index. give some example.

1638

What is an oracle wallet?

942

query optmization techniques and quwry analyser+projects+ppts

2419

How to work with data objects interactively?

982

Explain the use of indexes option in imp command.

1179

How to see free space of each tablespace?

1034

State some uses of redo log files?

1006

HI ALL, CAN ANYONE TELL ME THE DIFFERENCES BETWEEN SQL CLUSTURS,MSQL CLUSTERS,ORACLE CLUSTERS.......THANKS IN ADVANCE

2232

What is blob datatype?

1126

How to create a new user account in oracle?

1020

Why do we use bulk collect in oracle?

1058

How to use "for" statements in oracle?

1072

Describe varray?

1056

What is the usage of synonyms?

1141

How to store pictures on to the database?

973