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
- 14478 Views
- Accenture, Cognizant, I also Faced
- E-Mail Answers
Answer Posted / kondeti srinivas
emp table having depnto and dept table contains deptno
then only we can join the two table and find out max sal
dept wise
query:
select e.deptno,d.dname,max(e.sal) from emp e,dept d
where d.deptno=e.deptno
group by e.deptno,d.dname
| Is This Answer Correct ? | 5 Yes | 1 No |
Post New Answer View All Answers
What is the difference between teradata and basic rdbms?
What is a node in teradata? Explain
In Teradata, what is the significance of UPSERT command?
If a Node is busy what are the steps you can take to avoid ?
What are the different design perspectives used in teradata?
If Fast Load Script fails and only the error tables are made available to you, then how will you restart?
What do high confidence, low confidence and no confidence mean in explain plan?
What are the different methods ot loading a dimension table? A fact table etc?
What is basic teradata query language?
What is called partitioned primary index (ppi) and discuss the advantages of using it in a query?
how can we analyze the locks ?
What are aggregate tables? How do you design them using teradata?
what are the day to day activities of teradata DBA ?
What are the frequently used data types in teradata?
Explain the term 'database' related to relational database management system?
