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

What is VLDB?

1038

Explain normalization?

1098

what type of raid setup would you put your tx logs?

922

Explain the hierarchies level data warehousing.

868

How to export mappings to the production environment?

879

What is the difference between olap and oltp?

1031

What are fundamental stages of data warehousing?

1027

How many types of facts and what are they?

1003

What are components of report studio?

1022

How can we acheive correlated sub-query in designer?can anyone help me in this regard?

930

How many different schemas or dw models can be used in siebel analytics. I know only star and snow flake and any other model that can be used?

963

Why facts table is useful in representing the data?

983

What are the different problems that ?Data mining? can solve?

2805

what are the major three types of modeling used?

1052

What is the data type of the surrogate key?

984