select max(sal) from dept group by dname;

Disply the dname wise maximum salary

Question Posted / jilani

9 Answers
11729 Views
Principal Finance, I also Faced
E-Mail Answers

Answer Posted / jilani

select max(sal) from dept group by dname;

Is This Answer Correct ?

10 Yes

4 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

Explain the differences between normalizer and normalizer transformation?

1002

What is the difference between dependent data warehouse and independent data warehouse?

977

Explain what is the difference between power center & power mart?

976

How can you set the client management?

1004

Can you pass sql queries in filter transformation?

997

Explain what does level of granularity of a fact table signify?

942

what are relationships?

1021

Why facts table is useful in representing the data?

985

List any five applications of data warehouse.

931

what are confirmed dimension? We alwys give date as a conformed dimension but if it has different format for different contries say YYMMDD for italy and MM-DD-YYYY for france.Then are they not confirmed.

2227

Describe a data warehouse.

967

Explain what are the basic needs to join two sources in a source qualifier?

1101

Explain have you ever been in a real dilemma at work? What did you do to get out of it?

949

Explain what are data marts?

1097

Explain how are the dimension tables designed?

1035