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  

---

How to improve the query performance without taking the collect statistics? In explain plan i have 'NO CONFIDENT'.

2 Answers  

---

what is use of fload loading into set table?

2 Answers   IBM,

---

Suppose i have data like 2009/12/31 555555534 ' ' Generally last 2 records are wrong format it is going to error table but i don't want load error table if any wrong format in Date column Pass "NULL" how can we do it fast load

4 Answers  

---

how do you manage the production space. what are the proactive methods you can take ?

0 Answers  

---

Did you write stored procedures in teradata?

0 Answers  

---

hi guys...i have good experiance in oracle ...now i want to learn teradata? how much of percentage my knowledge is used to understand the teradata? i mean.. if teradata also having sql queries or not?

1 Answers  

---

How can we load single row of data into teradata database. please give me the process.

3 Answers  

---

What are default access rights in teradata? What explicit right can be given to a user?

0 Answers  

---

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

4 Answers   TCS,

---

How do you load Multiple files to a table by using fastload scripts?

1 Answers   Satyam,

---

What is multi insert?

0 Answers  

---