SELECT D.DEPTNO,D.DNAME,MAX(E.SAL) FROM EMP E,DEPT D WHERE D.DEPTNO=E.

Disply the dname wise maximum salary

Question Posted / naveen

Answer Posted / naveen

SELECT
D.DEPTNO,D.DNAME,MAX(E.SAL)
FROM
EMP E,DEPT D
WHERE
D.DEPTNO=E.DEPT.NO
GROUP BY D.DEPTNO,D.DNAME

Is This Answer Correct ?

12 Yes

1 No

Please Help Members By Posting Answers For Below Questions

What is factless fact tables?

1114

Can you brief about the Data warehouse project you worked on?

2315

What is data stream and data adaopter. Is it same are different? Explain?

915

How can we determine what records to extract?

1029

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

916

What are the types of SCD?

1093

What is defined as partial backup?

1023

What are Non-additive facts?

1112

Tell me what is degree of a relation?

936

Explain me what are data marts?

1004

Explain what is ods (operation data source)?

929

What are various warehousing tools?

918

For faster process, what we will do with the universe?

941

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

979

How did you plan your Data ware house project?

2242