Disply the dname wise maximum salary
Answer Posted / 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 |
Post New Answer View All Answers
Explain what are the various reporting tools in the market?
What are situations where snowflake schema is better than star schema when the opposite is true?
Define Data Warehousing?
Explain swot analysis?
Explain vldb?
What is the difference between metadata and data dictionary?
What is your spectra photometer working principles?
how much memory space occupied real time project (roughly)?
Explain what is a staging area? Do we need it? What is the purpose of a staging area?
What is difference between e-r modeling and dimensional modeling?
Explain what is what are semi-additive and factless facts and in which scenario will you use such kinds of fact tables?
What are fact, dimension, and measure?
Explain difference between view and materialized view?
What is an er diagram?
Explain what are the steps to build the data warehouse?