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
- 16394 Views
- Accenture, Cognizant, I also Faced
- E-Mail Answers
Answer Posted / subbareddy kake
with out using any Join conditions
Select deptno, max(sal)
from emp group by deptno
| Is This Answer Correct ? | 3 Yes | 1 No |
Post New Answer View All Answers
What are the scenarios in which full table scans occurs?
What are default access rights in teradata? What explicit right can be given to a user?
How can you track login parameters of users in teradata?
Explain the new features of teradata?
What are the various indexes in teradata?
Comment whether bottleneck is an error or not.
How to select first n records in teradata?
What is a clique?
Highlight the advantages of PPI(Partition Primary Index).
What is meant by a Least Cost Plan?
What are the different softwares used with their functions in teradata?
What do you mean by parsing?
Explain BYNET.
Why managing the data is important?
Explain PDE.
