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

Post New Answer



More Teradata Interview Questions

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

1 Answers   HP,


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

0 Answers  


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

2 Answers   IBM,


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

2 Answers   Wipro,


What interface is used to connect to windows based applications?

0 Answers  






What is the meaning of Caching in Teradata?

0 Answers  


What is dimensional modeling?

0 Answers  


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

6 Answers   IBM,


What do you mean by teradata intelliflex?

0 Answers  


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

2 Answers   Accenture, Nest, Spiro Solutions, South Nests Software Solution,


What is differnce between Error code and Error Level in Bteq

6 Answers   IBM,


how to load or extract the error table data ?

3 Answers  






Categories