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
- 16845 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
Explain parsing engine in teradata?
What are the scenarios in which full table scans occurs?
There is a column with date in it. If I want to get just month how it can be done? Can I use sub string?
In Teradata, what is the significance of UPSERT command?
Describe primary index in teradata. And what are the available primary index types?
What can be achieved by using the teradata rdbms?
Why are oltp database designs not generally a good idea for a data warehouse?
Explain the advantages of partitioned primary index in a query?
Mention the procedure via which, we can run Teradata jobs in a UNIX environment.
Comment whether bottleneck is an error or not.
Can you connect multiload from ab initio?
Syntax for case when statement?
What is node? How many nodes and amps used in your previous project?
Highlight the need for Performance Tuning.
Explain the parallel data extension in teradata?
