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,

---

why should we go Teradata over Oracle,what is the main differences?

4 Answers   TCS,

---

Write a single SQL to delete duplicate records from the a single table based on a column value. I need only Unique records at the end of the Query.

13 Answers  

---

If the script is aborted. why it is aborted and how can you identify ?

1 Answers  

---

What is a pseudo key? What is its use???

2 Answers   Mphasis,

---

Frnds.... i have one doubt we have the num like this +913757575......i want to remove 91 and i want lo load remaining data to the target table.. whinch function we can use in teradata????? Plz let me know.. thanks in advance

2 Answers  

---

What is teradata? Also, list out some of the primary characteristics of teradata.

0 Answers  

---

How many macros we can create inside a macro

1 Answers   Wipro,

---

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

3 Answers  

---

Hi frnds...can any one help me regarding this que.. We have column in a table name it as C1 WHICH CONTAIN ALPHANUMERIC AND NUMERIC VALUES. C1 2A 2B 2V 2H 1 2 3 4 5 i want to retrive numeric values like 1,2,3,4,5 How we can get Plz let me know.Thanks in advance

4 Answers   IBM,

---

What is upsert statement in teradata?

0 Answers  

---

What is spool space?

0 Answers  

---