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

Disply the dname wise maximum salary

Question Posted / reddeppa reddy

Answer Posted / reddeppa reddy

Is This Answer Correct ?

5 Yes

15 No

Please Help Members By Posting Answers For Below Questions

How can we load the time dimension?

1181

What is operational data store (ods)?

998

What are components of report studio?

1028

Explain er diagram?

980

How are models actually derived?

1990

How can you clear the cache?

981

How to pivot data using informatica when you have variable amount of pivot rows?

893

What are the differences between star and snowflake schema?

1083

Could any one explain me how to create cascading prompts?

1054

Explain some of modeling tools available in the market?

950

How to eliminate duplicate rows from flat file?

922

Hi, If any hav Informatica n DWH FAQ's,Plz do fwd to s.rajanikanth1980@gmail.com Thnx Vani

2246

Compare and contrast aggregates & indexes

3755

Define data warehouse?

1015

What are fundamental stages of data warehousing?

1032