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

Which are the olap tools available that are supported by oracle?

937

What is a full backup?

973

Why fact table is in a normal form?

997

What is meta data and system catalog?

2306

Where the applications and where

929

How many project sources we can create in metadata?

1095

Explain how many ways you create ports?

1027

Suppose a null dataset with 10 variables; I want to print only name of the varibales in log window and also output window. How can we do this one?

977

What is a relationship?

999

What is the difference between static cache and dynamic cache?

998

Explain in detail abt measure objects? And what is the use of it? How to create it?

1016

Why null values are mapped as 0 in fact tables?

1008

Explain swot analysis?

1171

Do you view contain data?

946

Difference between PowerPlay transformer and power play reports?

2523