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
- 16652 Views
- Accenture, Cognizant, I also Faced
- E-Mail Answers
Answer Posted / ram reddy
Prerequisite
-------------
Both emp and dept tables should have deptno column
select depno,max(sal)
from emp e,dept d
where e.deptno=d.deptno
group by deptno;
| Is This Answer Correct ? | 14 Yes | 5 No |
Post New Answer View All Answers
List out teradata data types?
What is upsert statement in teradata?
what are the day to day activities of teradata DBA ?
Describe primary index in teradata. And what are the available primary index types?
What does Amp contain and what are all the operations that it performs?
What is a dimension table?
Explain vproc in teradata?
Explain fastload in teradata?
Which is faster fastload or multiload?
How to explain project Architecture and flow in teradata interviews?Can please anyone help on this? Am new to teradata.
What are the commands to make a new table, change a table and remove a table in teradata?
How to view every column and the columns contained in indexes in teradata?
How teradata makes sure that there are no duplicate rows being inserted when its a set table?
what is sysdba and sysdbc ? which has high priority ?
What is the purpose of using case expression in teradata?
