Interested to Buy Any Domain ? << Click Here >> for more details...
Disply the dname wise maximum salary
- 9 Answers
- 11844 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 |
What is the difference between mapping parameter & mapping variable in data warehousing?
Disply the dname wise maximum salary
Explain how many ways you create ports?
What are the steps involved in designing a fact table?
Explain what are fact, dimension, and measure?
What are the different types of datawarehosuing?
Explain what are snapshots? What are materialized views & where do we use them? What is a materialized view log?
Why denormalization is promoted in universe designing?
What is a source qualifier?
Are facts same as metrics and dimensions same as measures? If not , please tell the difference?
What are modeling tools available in the market?
In my report contain product name, amount, country, sales person I want to create one prompt: sales territory.( Ex: asia, us, uk, aus), but territory column is not there in my model and source if u select the asia in prompt page-ll asian country results I want in report page I discussed with my friends and colleague, they told use the static choice function still I face this problem. If u know please tell me?
Teradata 
