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
- 16846 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
If RDBMS is halted what will you do ?
How is the teradata different from oracle?
What are the 5 phases in a multiload utility?
What is spool space?
What is difference between user and database in teradata?
How will you solve the problem that occurs during update?
How to run a query in teradata?
What do high confidence, low confidence and no confidence mean in explain plan?
What are the joins in teradata?
What are the different design perspectives used in teradata?
What do you mean by fastexport in teradata?
What is meant by a Least Cost Plan?
What is called partitioned primary index (ppi)?
What do you mean by parsing?
Is it necessary to add? Quit statement after a bteq query when I am calling it in a unix environment?
