SELECT d.dname,e.sal from emp e,dept d where e.deptno=d.deptno group by dn

Disply the dname wise maximum salary

Question Posted / lakshmi

Answer Posted / lakshmi

SELECT d.dname,e.sal from emp e,dept d where e.deptno=d.deptno
group by dname

Is This Answer Correct ?

2 Yes

2 No

Please Help Members By Posting Answers For Below Questions

What are the data types present in bo? What happens if we implement view in the designer n report?

924

Explain vldb?

1016

What are the different ways to represent the loading of dimension tables?

912

Why null values are mapped as 0 in fact tables?

982

Explain how are the dimension tables designed?

1032

What are parallel querys and query hints?

2209

What is a real-time data warehouse? How is it different from near to real-time data warehouse?

939

What is mean by aggregate aware?

1052

Explain difference between data ware house & data mart?

973

How do you call a module named �testmod.cfm� with the parameters param1=�yes� and param2=5?

987

Explain the difference between filter and conditin?

952

Explain what is the difference between stop and abort?

1018

What are fundamental stages of data warehousing?

1027

What are the steps to build the datawarehouse?

1027

Explain is fact table?

914