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.
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
What happens in a conflict? How do you handle that?
If RDBMS is halted what will you do ?
Backup Script was blocked then you are unable to archive the data. how do you analyze it and where do you identify ?
If a Node is busy what are the steps you can take to avoid ?
How do you define Teradata?
Explain vproc in teradata?
What is the use of fallback?
Can we collect statistics on table level?
Why teradata is used?
What is the function of parser component in teradata?
What are the various etl tools in the market?
What are the various reporting tools in the market?
Explain teradata utilities. What is multiload, fast load, tpump?
Describe primary index in teradata. And what are the available primary index types?
What is spool space? Why do you get spool space errors?