select departmentname,max(sal) from department table group by deptid

Disply the dname wise maximum salary

Question Posted / reddeppa reddy

Answer Posted / reddeppa reddy

select departmentname,max(sal) from department table group
by deptid

Is This Answer Correct ?

1 Yes

11 No

Please Help Members By Posting Answers For Below Questions

Explain difference between e-r modeling and dimentional modeling?

1034

How to define a cube??

991

How to test report in reportnet?

1052

Is there any default username & pwd for bo designer & supervisor?

1082

Explain what is a cube in data warehousing concept?

1025

What is the difference between power center & power mart?

1029

What are the various tools? Explain name a few?

1019

What is a linked cube?

1042

Explain the hierarchies level data warehousing.

931

how can one transfer LOB and user defined data from oracle to warehouse using ETL informaticabecause

2181

if you use oracle sql*loader , how do you transform data with it during loading?

2140

Difference between PowerPlay transformer and power play reports?

2557

what is difference between drill & scope of analysis?

1165

What is the difference between snowflake and star schema?

1095

How to generate the cubes in framework manager?

1095