Disply the dname wise maximum salary
Answers were Sorted based on User's Feedback
Answer / harsh sugandhi
select dname, max(sal) from dept group by dname;
Is This Answer Correct ? | 28 Yes | 0 No |
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
Is This Answer Correct ? | 12 Yes | 1 No |
Answer / gyana ranjan behera
SELECT DNAME,MAX(SAL) FROM DEPARTMANT_TABLE GROUP BY DNAME
Is This Answer Correct ? | 4 Yes | 0 No |
Answer / damreddy
Select deptname ,max(sal) from depttable group by depertmentName
Is This Answer Correct ? | 1 Yes | 1 No |
Answer / 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 |
Answer / divya
SELECT d.dname,max(e.sal) from emp e,dept d where e.deptno=d.deptno
group by d.dname
Is This Answer Correct ? | 0 Yes | 0 No |
select deptid, max(sal) from department table group by sal
Is This Answer Correct ? | 5 Yes | 15 No |
select departmentname,max(sal) from department table group
by deptid
Is This Answer Correct ? | 1 Yes | 11 No |
What is the main difference between star and snowflake star schema? Which one is better and why?
What is an er diagram?
Explain what are snapshots? What are materialized views & where do we use them? What is a materialized view log?
What is static and local variable?
What needs to be done when the database is shutdown?
What are the differences between star and snowflake schema?
What are the different types of data warehouses?
What are fact, dimension, and measure?
What is a fact table?
What are Aggregate tables?
What is crass reference table?
What is informatica architecture?