Interested to Buy Any Domain ? << Click Here >> for more details...
Disply the dname wise maximum salary
- 9 Answers
- 11527 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 |
Explain what is full load & incremental or refresh load?
Suggest a good author for hyperion in data warehousing?
wat is code review and wat actually srs or how can we create HLD,LLD.PLS,GIVE ME ANSWER AS EARLY AS FAST.
What is a look up function? What is default transformation for the look up function?
wht is degenerated dimension ?it's uses?
What are the advantages of query studio compared to report studio?
What is ?Data Warehousing??
What is static and local variable?
What is a fact table?
Can we take backup when the database is opened?
How to create different types of templates?
How would you write a left join statement to return a result set of movie.title�s and director.name�s?
Teradata 
