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.
Answers were Sorted based on User's Feedback
Answer / priya
AS emp table doesnt have a field as deptno so we cant find
a maxsal of each dept wise, as no common field is used
Is This Answer Correct ? | 12 Yes | 0 No |
Answer / 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 |
Answer / yuvaevergreen
Since there is no common column, it may not be possible to
join two tables.
if deptno is in emp table, correlated query can be used
emp
eno ename sal deptno
1 yuva 10 tn1
2 yuv1 20 tn2
3 yuv3 30 tn1
select * from emp as e1
where sal in
(sel max(sal) from emp as e2
where e1.deptno=e2.deptno);
Is This Answer Correct ? | 10 Yes | 1 No |
Answer / kondeti srinivas
emp table having depnto and dept table contains deptno
then only we can join the two table and find out max sal
dept wise
query:
select e.deptno,d.dname,max(e.sal) from emp e,dept d
where d.deptno=e.deptno
group by e.deptno,d.dname
Is This Answer Correct ? | 5 Yes | 1 No |
Answer / subbareddy kake
with out using any Join conditions
Select deptno, max(sal)
from emp group by deptno
Is This Answer Correct ? | 3 Yes | 0 No |
How to find duplicates in a table?
What is upsert statement in teradata?
What are the functions of a teradata dba?
can we load 10 millions of records into target table by using tpump?
If the PMON is not working then how do you manage and monitor all processes, resources and sessions etc.
Explain the meaning of Amp?
How would you load a very large file in teradata in general? What utility would you use for it? Why?
What is the default join strategy in Teradata???
Different phases of multiload?
how teradata fetches a row from primary index table?
What are the differences between TerdataV2R5 and V12 Versions please??
What is the purpose of joins in teradata?