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 critical column?

1255

What are the approaches used by optimizer during execution plan?

960

Explain what is a cube in data warehousing concept?

1025

What are universe requirements?

1112

How to reduce warnings?

988

What are the various methods of getting incremental records or delta records from the source systems?

993

What is data stream and data adaopter?

1131

What a static and local variable?

1133

What is a core dimension?

1115

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

982

Do you view contain data?

1004

How to load the time dimension?

1053

How to eliminate duplicate rows from flat file?

989

Explain dimension table ?

1039

What are aggregate tables and aggregate fact tables?

1092