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
- 16658 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 happens when a node suffers a downfall?
What is bteq utility in teradata?
What are the available primary index types in teradata.
What is teradata? Also, list out some of the primary characteristics of teradata.
Explain amp in teradata?
What is a clique?
Define views in teradata with syntax.
Why do you get spool space errors? How do trouble-shoot them?
What are the different softwares used with their functions in teradata?
Differentiate primary key and partition key?
List the logical and conditional operators that are used with teradata along with their meanings?
How is the teradata different from oracle?
What are the various indexes in teradata? How to use them?
How can bottlenecks be identified?
What's the difference between timestamp (0) and timestamp (6)?
