select e.ename,d.deptno,max(e.sal) from emp e, dept d where e.deptno = d.

two tables are there
emp(eno,ename,sal,deptno),dept(deptno,dname).how form the
query in deptno,ename,max(sal)

Question Posted / ajit

Answer Posted / ajit

select e.ename,d.deptno,max(e.sal)
from emp e, dept d
where e.deptno = d.deptno
group by e.ename, d.deptno;

Is This Answer Correct ?

4 Yes

2 No

Please Help Members By Posting Answers For Below Questions

What is an oracle transaction?

588

How does the on-delete-cascade statement work?

608

What is rowid and rownum in oracle?

544

Is rowid unique in oracle?

529

Is oracle a language?

522

Is there any function in oracle similar like group_concat of mysql?

539

How to drop a tablespace?

574

What is set verify off in oracle?

577

I have a database backup file in .db (ext) form how to conver it into .dmp (ext.) for oracle database

1633

How to convert csv to table in oracle?

528

how can db_files > maxdatafiles since db_files is for instance and the later is for database

2173

Explain the importance of .pll extension in oracle?

555

What is a package in oracle?

565

What are the logical operations?

677

What is the difference between substr and instr?

519