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

"A dimension table is wide but the fact table is deep," explain the statement in your own words.

1389

does anyone "QlikView" BI tool. if you have any docs send me pls. yaparas84@gmail.com

5975

Can a dimension table contain numeric values?

1063

Explain datawarehousing?

1059

After we create a scd table, can we use that particular dimension as a dimension table for star schema?

998

What is data analysis? Where it will be used?

989

Explain functional dependency?

1094

Explain the hierarchies level data warehousing.

888

How would you write a simple stored procedure in tsql which takes a movie_id and returns all the directors associated with it?

1009

How do you setup Lo-cockpit?

3172

What are the stages that are required in data warehousing?

964

How we are using this function?

1125

What is surrogate key? Where we use it?

997

What are steps we have to follow in designing the userfriendly universe?

980

Hyperion is the one of the tool in data ware house. Its an olap tool. Why you cant display that tool?

1022