Disply the dname wise maximum salary
Answer Posted / gyana ranjan behera
SELECT DNAME,MAX(SAL) FROM DEPARTMANT_TABLE GROUP BY DNAME
| Is This Answer Correct ? | 4 Yes | 0 No |
Post New Answer View All Answers
Explain difference between snow flake and star schema.
what are confirmed dimension? We alwys give date as a conformed dimension but if it has different format for different contries say YYMMDD for italy and MM-DD-YYYY for france.Then are they not confirmed.
Explain what is the limit to the number of sources and targets you can have in a mapping?
The same tier?
What is the main difference between inmon and kimball philosophies of data warehousing?
What is a staging area? Do we need it? What is the purpose of a staging area?
What are the other names given to data warehousing?
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?
How to calculate fact table granularity?
What are session timeout and application timeout?
What is application.cfm?
Explain what are the advantages of query studio compared to report studio?
What are templates in which way it is help full?
What is a cube in data warehousing concept?
Explain what are the possible data marts in retail sales?