Please tell me a query to find the Primary key,Foreign key,primary Index,PPI for the Database?

5 Answers  

---

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 is the purpose of indexes?

0 Answers  

---

Difference between star and snowflake schemas?

0 Answers  

---

How do you Generate sequence at the time of Display?

2 Answers   Infosys,

---

How to cast date "2015-03-03-012204-000000" to timestamp

1 Answers   Cognizant,

---

What is the purpose of joins in teradata?

0 Answers  

---

Hi All, can anyone tell me how many types of Skew exists? whats the difference between amp skew,data skew,cpu skew, io skew, delta amp cpu ?

2 Answers  

---

Hi frinds pls help me regarding this question WHY usi is two amp operation in teradata? THANKS IN ADVANCE....

3 Answers  

---

What is a node in teradata? Explain

0 Answers  

---

Explain the term 'columns' related to relational database management system?

0 Answers  

---

Hello Frndz, I have a table named product as shown below: product_id product_name 1 AAA 1 BBB 1 CCC 2 PPP 2 QQQ 2 RRR Now my output should be: product_id product_name_1 product_name_2 product_name_3 1 AAA BBB CCC 2 PPP QQQ RRR

4 Answers   Cap Gemini,

---