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
- 16847 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
When tpump is used instead of multiload?
How does hashing happens in teradata?
What are the different table types supported by teradata?
How to eliminate product joins in a teradata sql query?
What is the use of having index on table?
how many modules are there in telecome domain?how to explain the architecture?
Discuss the advantages of using partitioned primary index in a query?
How to write the query . eid enm doj dob i want to display the names who worked more than 25 years .
What is multi insert?
If I wanted to run a TPump job only once per day - basically working on a file that is produced once per day - how would you set up the parameters for that sort of job ?
What tools would you use for that?
What are the functions of a teradata dba?
How to identify ppi columns?
What are some commonly used bteq scripts?
While creating table my dba has fallback or no fallback in his ddl. What is that?
