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
How many different schemas or dw models can be used in siebel analytics. I know only star and snow flake and any other model that can be used?
What are the data types present in bo? What happens if we implement view in the designer n report?
For faster process, what we will do with the universe?
a perceptron has two inputs x1,x2 wih weights w1,w2and bias weight of w0. the activation function of perceptron is h(x).the output of perceptron
What is metadata in context of a datawarehouse and how it is important?
What are the other names given to data warehousing?
How to allow a dynamic selection of a column for a measure in a chart,without using variable?
What is is a star schema?
List any five applications of data warehouse.
What is a linked cube?
What is partitioning? What are the types of partitioning?
How to pivot row data using informatica?
Explain if a flat file cotains 1000 records how can I get first and last records only?
How can we run the graph? What is the procedure for that? How can we schedule the graph in unix?
What are the difference between snow flake and star schema?