Interested to Buy Any Domain ? << Click Here >> for more details...
Disply the dname wise maximum salary
- 9 Answers
- 12038 Views
- Principal Finance, I also Faced
- E-Mail Answers
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 can you clear the cache?
What is the difference between static cache and dynamic cache?
Suppose I want to get sales data for the last (suppose 10) dates dynamically using value prompt how can I do it and drag it onto report editor?
i have scheduled a report in a job in the cognos8.3 which would send the reports to the respective user ,now the repot ran and is sent to the respective user but it contains some unwanted data. So based on the senario can any one tell me that can we recall back the report ??????
How to explain any (sales) project in interview.actually feom where report developer work starts?pls reply as soon as possible?
How to stop a batch?
Can a dimension table contain numeric values?
What is a full backup?
Explain can a dimension table contains numeric values?
What is a data profile?
What are the key columns in Fact and dimension tables?
How can we acheive correlated sub-query in designer?can anyone help me in this regard?
What are the steps of implementing data warehousing?
Explain a mapping, session, worklet, workflow, mapplet?
Explain a linked cube?
