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
- 14428 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
Explain the term 'columns' related to relational database management system?
how can we analyze the locks ?
What is logical data model?
How can bottlenecks be identified?
How to Extract data from multiple legacy systems?
Can any one explain me the difference between BTEQ and MLOAD,TUMP. All canbe used for same purpose but still differnt methods. why ?
What is the purpose of upsert command?
In general, how do you optimze any sql in teradata?
what are the uses of fact table and dimension table in banking project?
My table got locked during mload due to a failed job. What do I do to perform other operations on it?
Give a justifiable reason why Multi-load supports NUSI instead of USI.
Explain teradata vs. Redshift?
What is teradata? Also, list out some of the primary characteristics of teradata.
What are the steps to create a data model?
Can we have an unconnected lkp to lookup a db2 record against a teradata record? Doesnt seem to work. I could be wrong
