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
- 14429 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 | 0 No |
Post New Answer View All Answers
What are the available primary index types?
Explain and compare pros and cons of start schemas?
How do you do backup and recovery in teradata?
Explain how spool space is used.
How will you solve the problem that occurs during update?
What are the steps to create a data model?
Describe primary index in teradata. And what are the available primary index types?
What is meant by a dispatcher?
What is node? How many nodes and amps used in your previous project?
What is bteq utility in teradata?
Discuss the advantages of using partitioned primary index in a query?
If I wanted to run a TPump job only once per day - basically working on a file that is produced once per day - how would you set up the parameters for that sort of job ?
How to Extract data from multiple legacy systems?
What is meant by a Parsing Engine?
How do you see a ddl for an existing table?
