Disply the dname wise maximum salary
Answer Posted / harsh sugandhi
select dname, max(sal) from dept group by dname;
| Is This Answer Correct ? | 28 Yes | 0 No |
Post New Answer View All Answers
The same tier?
How to limit the max no of rows retrieved in the report?
Suppose you are filtering the rows using a filter transformation only the rows meet the condition pass to the target. Tell me where the rows will go that does not meetthe condition.
What is is a star schema?
Describe the differences between a data warehouse and data mart.
What is freehand sql?
What are the different types of data warehousing?
what are the major three types of modeling used?
Why should you put your data warehouse on a different system than your oltp system?
What is an IDQ file? What is the purpose of the IDQ file and what kindof information does it usualy hold? Can it be imported by informatica?
What is the main difference between star and snowflake star schema? Which one is better and why?
What needs to be done when the database is shutdown?
How to pivot row data using informatica?
What are the different types of schemas used in data warehousing?
Explain why are oltp database designs not generally a good idea for a data warehouse?