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
- 16657 Views
- Accenture, Cognizant, I also Faced
- E-Mail Answers
Answer Posted / priya
AS emp table doesnt have a field as deptno so we cant find
a maxsal of each dept wise, as no common field is used
| Is This Answer Correct ? | 12 Yes | 0 No |
Post New Answer View All Answers
What is basic teradata query language?
Why managing the data is important?
How to eliminate product joins in a teradata sql query?
Why teradata is used?
What are the various etl tools in the market?
List out some of the primary characteristics of teradata.
What is the syntax for case when statement?
How teradata makes sure that there are no duplicate rows being inserted when its a set table?
What is the use of teradata system software?
Explain teradata architecture in detail with a diagram.
what is object level locking ? where do appear this type of locking ?
Differentiate primary key and partition key?
What are the primary characteristics of the Teradata.
How do you create tables? Exact syntax, and create profiles, users in teradata?
How do you do backup and recovery in teradata?
