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
- 16476 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 5 phases in a multiload utility?
Did you write stored procedures in teradata?
Explain teradata vs. Redshift?
What are the steps involved in the process flow of the sql statement through channel attached system?
How to explain project Architecture and flow in teradata interviews?Can please anyone help on this? Am new to teradata.
What is the maximum number of dml can be coded in a multiload script?
What are the available primary index types in teradata.
What are the main components of teradata system?
What are different table types used in teradata?
What is meant by a Highest Cost Plan?
What is the difference between fastload and multiload?
What do you mean by caching in teradata?
Give a justifiable reason why Multi-load supports NUSI instead of USI.
How do you do backup and recovery in teradata?
What are the design features involved in teradata?
