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
Explain the parallel data extension in teradata?
Highlight the points of differences between the database and user in Teradata.
What is smp and mpp platforms?
How do you determine the number of sessions?
Explain the term 'tables' related to relational database management system?
What do you mean by teradata intellicloud?
What are differences between teradata and ansi session modes in teradata?
What is collect statistics?
List out all forms of LOCKS that are available in Teradata.
What is spool space?
What is a three-tier data warehouse?
what is object level locking ? where do appear this type of locking ?
What is meant by Teradata Gateway?
Explain PDE.
What are the functions performed by bynet?