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.
Answer Posted / yuvaevergreen
Hi Vinay,
Thanks ya for the catch and appre...
Hi guys,
Please ignore the first approach using the delete statement. It is wrong.
| Is This Answer Correct ? | 5 Yes | 0 No |
Post New Answer View All Answers
Explain how spool space is used.
What are tpump utility limitations?
If I wanted to run a TPump job only once per day - basically working on a file that is produced once per day - how would you set up the parameters for that sort of job ?
What interface is used to connect to windows based applications?
what are the uses of fact table and dimension table in banking project?
What exactly do you know about catching in teradata?
Why teradata is used?
Describe the set operators in teradata.
What is spool space?
Why managing the data is important?
What is meant by Teradata Gateway?
Can you fastexport a field, which is primary key by putting equality on that key?
Difference between multiload and tpump?
What are the various indexes in teradata? How to use them? Why are they preferred?
What is spool space? Why do you get spool space errors? How do trouble-shoot them?