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
- 15005 Views
- Accenture, Cognizant, I also Faced
- E-Mail Answers
Answer Posted / 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;
| Is This Answer Correct ? | 14 Yes | 5 No |
Post New Answer View All Answers
Different phases of multiload?
how can we analyze the locks ?
Can we collect statistics on table level?
List out some of the primary characteristics of teradata.
What do you mean by teradata intellicloud?
What is difference between user and database in teradata?
What do you mean by caching in teradata?
What do you mean by teradata intelliflex?
Why do you get spool space errors? How do trouble-shoot them?
What are the various reporting tools in the market?
What is oltp?
If a Node is busy what are the steps you can take to avoid ?
How can you track login parameters of users in teradata?
Define views in teradata with syntax.
Hi Friends, Please send me Teradata Materials for certifications Thanks in advance !!
