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
- 14341 Views
- Accenture, Cognizant, I also Faced
- E-Mail Answers
Answer Posted / 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 View All Answers
What are the different methods ot loading a dimension table? A fact table etc?
Explain the teradata primary index mechanics in detail with a diagram.
What are some primary characteristics of teradata?
Highlight the differences between Primary Key and Primary Index.
How do you verify a complicated sql?
What are the different table types supported by teradata?
List out teradata data types?
What is the purpose of joins in teradata?
What is a node in teradata?
What is multi insert?
any one answer me how they can analyzing the project using data ware housing?
How do you determine the number of sessions?
My table got locked during mload due to a failed job. What do I do to perform other operations on it?
Name the five phases that come under MultiLoad Utility.
Highlight the limitations of TPUMP Utility.
