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,

---

While creating table my dba has fallback or no fallback in his ddl. What is that?

0 Answers  

---

i have column like below studentid studentname sub1 sub2 sub3 1 aaa 40 70 90 2 bbb 60 80 50 i want to execute every student highest mark in which subject my o/p like below studentid studentname sub3 sub2 1 aaa 90 2 bbb 80

12 Answers   CTS,

---

If a Node is busy what are the steps you can take to avoid ?

0 Answers   Teradata,

---

Highlight the limitations of TPUMP Utility.

0 Answers  

---

What are the various indexes in teradata? Why are they preferred?

0 Answers  

---

if collect stats but it show low confidence why?

0 Answers   IBM,

---

Give the sizes of SMALLINT, BYTEINT and INTEGER.

0 Answers  

---

Highlight the need for Performance Tuning.

0 Answers  

---

What are the advantages of teradata?

0 Answers  

---

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

1 Answers   Cognizant,

---

How do you see a ddl for an existing table?

0 Answers  

---