I have a employee table with EMPID, EMPNAME, DEPTID, SAL and want to fetch the maximum and minimum salary on each dept id with the emp name. Can anyone help in this? The result should contain the EMPNAME, DEPTID, SAL.

4 Answers   Cap Gemini,

---

What are some primary characteristics of teradata?

0 Answers  

---

what are the default access rights in the teradata?

1 Answers  

---

how to load or extract the error table data ?

3 Answers  

---

Why do Hash joins usually perform better than Merge Joins?

1 Answers  

---

---

Is PK concept available in Teradata. If it is how can we create Primary Key for a table in TD

6 Answers   Wipro,

---

What is Difference b/w PI & PPI?how to implement PPI?

3 Answers   Wipro,

---

A Query was run fine earlier. It is not running properly now. what are proactive steps you can take as a dba ?

1 Answers  

---

Can u load same data into multiple tables using multiload? How will be the loading process? Whether it will be serially or parallely?

2 Answers   IBM,

---

What do you mean by teradata intelliflex?

0 Answers  

---

Hi Frnds this que is recently asked at IBM there are two rows like aa6588fhfhf,gru282vbvv. Question is howcan we retrive the first number from two rows. Can any one help thanks in advance

5 Answers   IBM,

---

What is the process to restart the multiload if it fails?

7 Answers  

---