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   Accenture, Cognizant,

---

What are types of partition primary index (ppi) in teradata?

0 Answers  

---

How do you eliminate duplicates?

3 Answers  

---

How to handle nulls in Teradata??? How many columns can be there in a table??? How to find average sal with out using avg function????

3 Answers   Mphasis,

---

can we have an unconnected lkp to lookup a DB2 record against a Teradata record?

3 Answers  

---

Different phases of multiload?

0 Answers  

---

in ur table contains the coloumns like deptno,sal empname then i want output as deptno subtotalofdept totalsal 10 3700 3700 20 3400 7100 like that

1 Answers   IBM,

---

How many tables can you join in v2r5?

0 Answers  

---

Hi Friends I have a sql question, We have the source data as below. 101 address1, address2, address3 and the output shoulb like below 101 address1 101 address2 101 address3 Required a SQL query for this output. Please let me know if you have any sql query for this. Thanks in advance. Hari M

6 Answers   JPMorgan Chase,

---

Difference between Qualify and group

4 Answers   CTS,

---

What is the purpose of using case expression in teradata?

0 Answers  

---

Discuss the advantages of using partitioned primary index in a query?

0 Answers  

---