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
- 16393 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
If the PMON is not working then how do you identify and monitor all the processes, resources and sessions ?
tomorrow i have interview in infosys.can someone pour any suggestions or any interview questions. thank you
Explain and compare pros and cons of start schemas?
In Teradata, what is the significance of UPSERT command?
How do you create tables? Exact syntax, and create profiles, users in teradata?
What is the use of teradata system software?
Explain the term 'tables' related to relational database management system?
What is meant by a dispatcher?
What happens when a node suffers a downfall?
What is the command in bteq to check for session settings ?
Hi Friends, Please send me Teradata Materials for certifications Thanks in advance !!
If the PMON is not working then how do you manage and monitor all processes, resources and sessions etc.
What is the particular designated level at which a LOCK is liable to be applied in Teradata?
What is teradata?
What do you mean by teradata sql assistant?
