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
- 14427 Views
- Accenture, Cognizant, I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
Explain teradata utilities?
Explain teradata architecture?
Explain the parallel data extension in teradata?
What is the basic syntax for teradata select statement?
How will you solve the problem that occurs during update?
What is called partitioned primary index (ppi) and discuss the advantages of using it in a query?
Explain the meaning of Amp?
What are the joins in teradata and how many types of joins are there in teradata?
Name the five phases that come under MultiLoad Utility.
How can bottlenecks be identified?
What are the various indexes in teradata?
What is a node in teradata?
What are the available join types in teradata?
Explain teradata architecture in detail with a diagram.
Give the sizes of SMALLINT, BYTEINT and INTEGER.
