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.
- 5 Answers
- 14336 Views
- Accenture, Cognizant, I also Faced
- E-Mail Answers
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 |
Post New Answer View All Answers
What is the purpose of upsert command?
What is teradata? Also, list out some of the primary characteristics of teradata.
How teradata makes sure that there are no duplicate rows being inserted when its a set table?
Explain teradata architecture in detail with a diagram.
What do you mean by tpt in teradata?
What are the newly developed features of Teradata?
In general, how do you optimze any sql in teradata?
Did you write stored procedures in teradata?
What are different table types used in teradata?
What are the steps to create a data model?
Explain vproc in teradata?
In BTEQ, how are the session-mode parameters being set?
What are the different design perspectives used in teradata?
What is stored procedure in teradata?
Describe the set operators in teradata.
