AS emp table doesnt have a field as deptno so we cant find a maxsal of ea

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.

Question Posted / priya

Answer Posted / 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

Please Help Members By Posting Answers For Below Questions

Explain vproc in teradata?

938

Did you write stored procedures in teradata?

1055

How do you do backup and recovery in teradata?

960

In Teradata, how do we Generate Sequence?

980

What is oltp?

913

Explain fastload in teradata?

1037

How to explain project Architecture and flow in teradata interviews?Can please anyone help on this? Am new to teradata.

4319

What is the difference between fastload and multiload?

1285

What is the difference between global temporary tables and volatile temporary tables?

1081

If the PMON is not working then how do you manage and monitor all processes, resources and sessions etc.

2098

Explain some differences between mpp and smp?

1035

What is meant by Teradata Gateway?

1002

Where is teradata rdbms used?

1035

What is real time and near real time data warehousing?

1060

List out some of the primary characteristics of teradata.

924