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.
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
Explain the new features of teradata?
In a table can we use primary key in one column and in another column both unique and not null constrains.if yes how?
Explain the term 'columns' related to relational database management system?
Differentiate database data and data warehouse data?
If the PMON is not working then how do you manage and monitor all processes, resources and sessions etc.
What is the use of having index on table?
How to run a query in teradata?
What is the difference between teradata and oracle?
What is dimensional modeling?
What is teradata and why it is used?
Explain fallback in teradata?
What exactly do you know about catching in teradata?
Give a justifiable reason why Multi-load supports NUSI instead of USI.
What are the components provided on node?
How to Extract data from multiple legacy systems?