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
- 16403 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 are the string manipulation operators and functions associated with teradata?
Backup Script was blocked then you are unable to archive the data. how do you analyze it and where do you identify ?
What are the various indexes in teradata? Why are they preferred?
How teradata makes sure that there are no duplicate rows being inserted when its a set table?
How do you do backup and recovery in teradata?
how do you manage the production space. what are the proactive methods you can take ?
Explain the term 'primary key' related to relational database management system?
What is real time and near real time data warehousing?
What do you mean by fastexport in teradata?
What exactly do you know about catching in teradata?
What is the particular designated level at which a LOCK is liable to be applied in Teradata?
How will you solve the problem that occurs during update?
What is the purpose of indexes?
List out all forms of LOCKS that are available in Teradata.
How do you create tables? Exact syntax, and create profiles, users in teradata?
