Interested to Buy Any Domain ? << Click Here >> for more details...
Disply the dname wise maximum salary
- 9 Answers
- 12067 Views
- Principal Finance, I also Faced
- E-Mail Answers
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 |
Why fact table is in a normal form?
What are the advantages of cold fusion?
What is aggregate awareness?
Explain a linked cube?
What are algorithms provided by Microsoft in SQL Server?
How we are using this function?
How do we design a universe?
Explain the definition of normalized and denormalized view?
What a static and local variable?
Is union transormation is active transformation?
What are the design methods of data warehousing?
What are situations where snowflake schema is better than star schema when the opposite is true?
Teradata 
