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
- 16482 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
Highlight the advantages of PPI(Partition Primary Index).
Highlight a few of the important components of Teradata?
What are the various reporting tools in the market?
Can you connect multiload from ab initio?
What are the various etl tools in the market?
What exactly do you know about catching in teradata?
Define views in teradata with general syntax.
How will you solve the problem that occurs during update?
What are the things to be considered while creating secondary index?
What are the functions involved in shared information architecture?
What do you mean by teradata sql assistant?
if collect stats but it show low confidence why?
What is the use of stored procedures in teradata?
What is meant by a node?
what are the day to day activities of teradata DBA ?
