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

Disply the dname wise maximum salary

Question Posted / divya

Answer Posted / divya

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

Is This Answer Correct ?

0 Yes

0 No

Please Help Members By Posting Answers For Below Questions

What is many-to-many dimensional model in datawarehousing ?

922

Database in use is oracle?

1046

Explain datawarehousing?

1040

How to export mappings to the production environment?

886

What are partition points?

1047

What is the function of etl when used in data warehousing?

941

Explain what is fact less fact table? Where you have used it in your project?

918

ware house management system is used?

992

What are session timeout and application timeout? Where we have to do this process?

1020

What is the advantages data mining over traditional approaches?

960

List down some of the real time data-warehousing tools?

958

How many types of facts and what are they?

1009

What are the stages that are required in data warehousing?

943

What is surrogate key? Where we use it explain with example?

918

Explain what are the advantages data mining over traditional approaches?

1147