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

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;

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);

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

Answer / subbareddy kake

with out using any Join conditions

Select deptno, max(sal)
from emp group by deptno

What are the different table types that are supported by teradata?

0 Answers  

List the logical and conditional operators that are used with teradata along with their meanings?

0 Answers  

what are the uses of fact table and dimension table in banking project?

0 Answers   TCS,

What are the components used in smp and massively parallel processing (mpp) machines?

0 Answers  

Describe the between keyword in teradata?

0 Answers  

If the PMON is not working then how do you identify and monitor all the processes, resources and sessions ?

0 Answers  

Difference between stored procedure and macro?

0 Answers  

What are the different design perspectives used in teradata?

0 Answers  

What are the functions of a teradata dba?

0 Answers  

How does indexing improve query performance?

4 Answers   Satyam,

Hi All, can anyone tell me how many types of Skew exists? whats the difference between amp skew,data skew,cpu skew, io skew, delta amp cpu ?

2 Answers  

What is stored procedure in teradata?

0 Answers