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
- 15004 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 teradata?
What interface is used to connect to windows based applications?
What are the scenarios in which full table scans occurs?
What is meant by a dispatcher?
What is oltp?
List out some of the primary characteristics of teradata.
Explain fastload in teradata?
How many types of joins are there in teradata?
How to Extract data from multiple legacy systems?
Why do you get spool space errors? How do trouble-shoot them?
What is a sparse index?
What is the use of stored procedures in teradata?
how can we analyze the locks ?
How many codd's rules are satisfied by teradata database?
What are some commonly used bteq scripts?
