Interested to Buy Any Domain ? << Click Here >> for more details...
we have two tables emp,dept.emp has eno,ename,sal and dept
has deptno,dname.how to find maxsal of each dept wise.which
join used for joining.
- 5 Answers
- 16402 Views
- Accenture, Cognizant, I also Faced
- E-Mail Answers
Answer Posted / ram reddy
Prerequisite
-------------
Both emp and dept tables should have deptno column
select depno,max(sal)
from emp e,dept d
where e.deptno=d.deptno
group by deptno;
| Is This Answer Correct ? | 14 Yes | 5 No |
Post New Answer View All Answers
What is logical data model?
What does sleep function does in fast load?
What are the primary characteristics of the Teradata.
Hi send me the Teradata dumps to my id rajeshanantha@yahoo.co.in Thanks Rajesh. A
Comment whether bottleneck is an error or not.
Explain amp in teradata?
What is node? How many nodes and amps used in your previous project?
How you will check the version of teradata?
How do you do backup and recovery in teradata?
What do you mean by tpt in teradata?
What is meant by a Parsing Engine?
What is the purpose of using case expression in teradata?
What do you mean by ttu in teradata?
What are the functions of a Parser?
What is TPD?
