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
- 14342 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
Why do you get spool space errors? How do trouble-shoot them?
how can we analyze the locks ?
In a table can we use primary key in one column and in another column both unique and not null constrains.if yes how?
How to find duplicates in a table?
Describe primary index in teradata. And what are the available primary index types?
List the logical and conditional operators that are used with teradata along with their meanings?
How is MLOAD Teradata Server restarted after execution?
What is bteq utility in teradata?
What are the different softwares used with their functions in teradata?
What are the main components of teradata system?
What is meant by a Parsing Engine?
Differentiate database data and data warehouse data?
Highlight the points of differences between the database and user in Teradata.
If Fast Load Script fails and only the error tables are made available to you, then how will you restart?
How do you define Teradata?
