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 |
After we create a scd table, can we use that particular dimension as a dimension table for star schema?
What is your spectra photometer working principles?
What are the key features of chameleon that separates it from other algorithms?
What is factless fact tables?
Explain what is the difference between view filter and report filter?
which automation tool is used in data warehouse testing?
What are situations where snowflake schema is better than star schema when the opposite is true?
What is the difference between view materialized view and view?
Suppose your client wants to ensure only specific users can create reports in query studio with other users creating reports using report studio. How can this be accomplished?
What we will do with the universe for faster process?
What are the various transformation available?
Explain difference between snow flake and star schema.