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
- 16656 Views
- Accenture, Cognizant, I also Faced
- E-Mail Answers
Answer Posted / yuvaevergreen
Since there is no common column, it may not be possible to
join two tables.
if deptno is in emp table, correlated query can be used
emp
eno ename sal deptno
1 yuva 10 tn1
2 yuv1 20 tn2
3 yuv3 30 tn1
select * from emp as e1
where sal in
(sel max(sal) from emp as e2
where e1.deptno=e2.deptno);
| Is This Answer Correct ? | 10 Yes | 1 No |
Post New Answer View All Answers
What is collect statistics?
List out all forms of LOCKS that are available in Teradata.
Highlight the need for Performance Tuning.
Explain some differences between mpp and smp?
Give a justifiable reason why Multi-load supports NUSI instead of USI.
What is the use of fallback?
Why are oltp database designs not generally a good idea for a data warehouse?
What are the multiload utility limitations?
Explain the teradata primary index mechanics in detail with a diagram.
What are the functions performed by bynet?
What is meant by Teradata Gateway?
Hi Friends, Please send me Teradata Materials for certifications Thanks in advance !!
Why do you get spool space errors? How do trouble-shoot them?
What are the various reporting tools in the market?
What are the uses of client software involved in teradata?
