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


Please Help Members By Posting Answers For Below Questions

What happens in a conflict? How do you handle that?

590


If RDBMS is halted what will you do ?

1681


Backup Script was blocked then you are unable to archive the data. how do you analyze it and where do you identify ?

1481


If a Node is busy what are the steps you can take to avoid ?

1847


How do you define Teradata?

583






Explain vproc in teradata?

542


What is the use of fallback?

530


Can we collect statistics on table level?

577


Why teradata is used?

551


What is the function of parser component in teradata?

599


What are the various etl tools in the market?

553


What are the various reporting tools in the market?

589


Explain teradata utilities. What is multiload, fast load, tpump?

544


Describe primary index in teradata. And what are the available primary index types?

520


What is spool space? Why do you get spool space errors?

488