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

we have two tables emp,dept.emp has eno,ename,sal and dept has deptno,dname.how to find maxsal of e..

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

we have two tables emp,dept.emp has eno,ename,sal and dept has deptno,dname.how to find maxsal of e..

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

we have two tables emp,dept.emp has eno,ename,sal and dept has deptno,dname.how to find maxsal of e..

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

we have two tables emp,dept.emp has eno,ename,sal and dept has deptno,dname.how to find maxsal of e..

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

we have two tables emp,dept.emp has eno,ename,sal and dept has deptno,dname.how to find maxsal of e..

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

More Teradata Interview Questions

can we load 10 millions of records into target table by using tpump?

What is the particular designated level at which a LOCK is liable to be applied in Teradata?

what is the difference between primary index and secondary index?.

where we can use the delimiter in mload? pls let me know

What interface is used to connect to windows based applications?

What is the meaning of Caching in Teradata?

What is dimensional modeling?

what is the query for retrieve the unique values(not display the duplicates values) from single table?

What do you mean by teradata intelliflex?

how to delete duplicate records in multi set table without using any tables

What is differnce between Error code and Error Level in Bteq

how to load or extract the error table data ?

Categories