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 the various indexes in teradata? How to use them?

0 Answers  

---

what are the default access rights in the teradata?

1 Answers  

---

What are the advantages of teradata?

0 Answers  

---

What is dimensional modeling?

0 Answers  

---

---

Can any one please provide me practical example of How to do the performance tuning in Query??

5 Answers   Amdocs,

---

How will you solve the problem that occurs during update?

0 Answers  

---

what are the day to day activities of teradata DBA ?

0 Answers   TCS,

---

Did you write stored procedures in teradata?

0 Answers  

---

IBM QUESTION As all we know PE takes the SQL Request and it will give responce for that query. what is the internal process happening.how it is taking that sql from the system????? thanks in Advance

2 Answers   Cap Gemini, IBM, Infosys,

---

Hi Friends, Please send me Teradata Materials for certifications Thanks in advance !!

0 Answers   HP,

---

What is the difference between union and union all in teradata?

0 Answers  

---