Interested to Buy Any Domain ? << Click Here >> for more details...
Disply the dname wise maximum salary
- 9 Answers
- 11623 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 |
Where the applications and where
what is difference between Independent Data Mart Dependent Data Mart 1- 1- 2- 2- 3- 3- 4- 4-
What is the difference between static cache and dynamic cache?
Explain multivalued dependency?
How can you set the session management?
How to handle multi value dimensions?
Difference between cold fusion 5 and cold fusion mx 6?
Code the tables statement to produce a multi-level frequency?
What are the difference between snow flake and star schema?
what is table partitioning? How it is useful to warehouse database?
How can you implement many relations in star schema model?
How do you create surrogate key using ab initio?
Teradata 
