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
What are the stages of datawarehousing?
What is ods (operation data source)?
Which component has onread method and what it is used for?
What are modeling tools available in the market?
How did you plan your Data ware house project?
How can you implement many relations in star schema model?
What is the main difference between star and snowflake star schema? Which one is better and why?
In my report contain product name, amount, country, sales person I want to create one prompt: sales territory.( Ex: asia, us, uk, aus), but territory column is not there in my model and source if u select the asia in prompt page-ll asian country results I want in report page I discussed with my friends and colleague, they told use the static choice function still I face this problem. If u know please tell me?
What is meant by metadata in context of a data warehouse?
What is incremintal loading?
Explain the data types present in bo n wht happens if we implement view in the designer n report?
Explain why are oltp database designs not generally a good idea for a data warehouse?
Explain what are non-additive facts in detail?
Which are the olap tools available that are supported by oracle?
Ist the schema that a data warehouse system can implements.