Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 16848 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
What is TPD?
Can you fastexport a field, which is primary key by putting equality on that key?
What are the available join types in teradata?
What is the primary index in teradata?
What is spool space? Why do you get spool space errors? How do trouble-shoot them?
What are differences between teradata and ansi session modes in teradata?
Explain vproc in teradata?
What are the functions of a Parser?
How many types of joins are there in teradata?
How to load specific no.of records using bteq, or fastload,or multiload
What are the 5 phases in a multiload utility?
What are the different functions included in the server software?
What are the different table types supported by teradata?
if collect stats but it show low confidence why?
How is MLOAD Client System restarted after execution?
