Answer / harsh sugandhi

select dname, max(sal) from dept group by dname;

Answer / naveen

SELECT
D.DEPTNO,D.DNAME,MAX(E.SAL)
FROM
EMP E,DEPT D
WHERE
D.DEPTNO=E.DEPT.NO
GROUP BY D.DEPTNO,D.DNAME

Answer / jilani

select max(sal) from dept group by dname;

Answer / gyana ranjan behera

SELECT DNAME,MAX(SAL) FROM DEPARTMANT_TABLE GROUP BY DNAME

Answer / damreddy

Select deptname ,max(sal) from depttable group by depertmentName

Answer / lakshmi

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

Answer / divya

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

Answer / reddeppa reddy

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

Answer / reddeppa reddy

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

what is the synchonus? wht is the diff between synchronous and asynchronous what is the diff between v1 and v2 v3 delta modes in sap ecc

0 Answers   IBM,

Describe a data warehouse.

0 Answers  

After the complete generation of a report who will test the report and who will analyze it?

0 Answers  

What is the difference between data warehouse and operational systems?

0 Answers  

How many clustered indexes can u create for a table in dwh? In case of truncate and delete command what happens to table, which has unique id.

0 Answers  

Which parameter specified in the default storage clause of create tablespace cannot be altered after creating the table space?

0 Answers  

what are the other factors of the database on which the loading performance depend?

0 Answers  

What is called data cleaning?

0 Answers  

What is ETL process in Data warehousing?

3 Answers  

What is data type of the surrogate key?

0 Answers  

What is a ETL/ How does Oracle support the ETL process?

1 Answers  

What is Analysis Services?

0 Answers