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.
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 meant by a Channel Driver?
What are differences between teradata and ansi session modes in teradata?
What are different table types used in teradata?
How can bottlenecks be identified?
Where is teradata rdbms used?
Highlight the advantages of PPI(Partition Primary Index).
What is inner join and outer join?
Explain Teradata performance tuning and optimization?
What are teradata utilities?
How to write the query . eid enm doj dob i want to display the names who worked more than 25 years .
Explain the teradata primary index mechanics in detail with a diagram.
Explain teradata architecture in detail with a diagram.
What is the difference between fastload and multiload?
What is basic teradata query language?
hi frnds i want to learn teradata utilities and teradata dba real time. i have 1+ years of experience in teradata. so i want to go deeply in Tearada. plz let me know at my email id who r best to learn from. im lookng for a realtime guy in HYD or Banglr. Thanks in advance. Rajesh my email-id: rajeshmss87@gmail.com