Disply the dname wise maximum salary
Answer Posted / 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 |
Post New Answer View All Answers
What are diagrams?
Explain what is power center repository?
Explain bus schema?
What is the difference between snowflake and star schema? What are situations where snowflake schema is better than star schema when the opposite is true?
How to pivot row data using informatica?
What is dimensional modelling?
Explain the process of extracting data from source systems,storing in ods and how data modeling is done?
What are the methodologies of data warehousing?
What is vdl (view definition language) explain?
What are the different types of fact tables used in data warehousing?
What is a fact, dimension, measure?
Code the tables statement for a single-level (most common) frequency?
What are the steps to build the datawarehouse?
Explain how many ways you create ports?
What is data analytics in simple terms?