Interested to Buy Any Domain ? << Click Here >> for more details...
Disply the dname wise maximum salary
- 9 Answers
- 12068 Views
- Principal Finance, I also Faced
- E-Mail Answers
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
does anyone "QlikView" BI tool. if you have any docs send me pls. yaparas84@gmail.com
What are the different types of datawarehosuing?
Explain how to export mappings to the production environment?
How to handle multi value dimensions?
Explain the definition of normalized and denormalized view and what are the differences between them?
what are the others of "bad files" and "discard files" when using sql*loader?
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 improve session performance in aggregator transformation?
What is a real-time data warehouse? How is it different from near to real-time data warehouse?
What are parallel querys and query hints?
What is a staging area? Do we need it? What is the purpose of a staging area?
Explain what is full load & incremental or refresh load?
Suppose date is 05sep2005; I want the output like 05sep2005:00:00:00 ; how it will come?
Explain can a dimension table contains numeric values?
How to join 3 database like flat file, oracle, db2 in informatrica?
