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

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

Question Posted / harika

Answer Posted / harika

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

Is This Answer Correct ?

3 Yes

6 No

Please Help Members By Posting Answers For Below Questions

what is IDE,DMV in sql server?

2252

What is a private synonym?

1088

What is the difference between postgresql and oracle?

508

Explain the use of control file?

658

How to turn on or off recycle bin for the session?

610

How to name query output columns in oracle?

692

What are the different windows events activated at runtime ?

2410

In the oracle version 9.3.0.5.0, what does each number shows?

753

Explain a synonym?

608

What is a schema in oracle?

548

What is the usage of analyze command in oracle?

615

How to concatenate two text values in oracle?

593

What do you understand by database schema and what does it hold?

598

How do I know if oracle is installed on windows?

488

When do I need to use a semicolon vs a slash in oracle sql?

594