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
- 16433 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 are the various indexes in teradata? Why are they preferred?
What are the available primary index types in teradata.
How many tables can you join in v2r5?
Explain the new features of teradata?
What are the frequently used data types in teradata?
Which is faster fastload or multiload?
What are the steps to create a data model?
What is teradata? Also, list out some of the primary characteristics of teradata.
Explain the term 'tables' related to relational database management system?
What is logical data model?
Difference between inner join and outer join?
What is the difference between teradata and oracle?
Backup Script was blocked you are unable to archive the data now. how do you analyze it and where do you identify ?
What are the joins in teradata?
How many codd's rules are satisfied by teradata database?
