Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 59032 Views
- I also Faced
- E-Mail Answers
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
Give the sizes of SMALLINT, BYTEINT and INTEGER.
Can we collect statistics on multiple columns?
What can be achieved by using the teradata rdbms?
What are the available primary index types in teradata.
A certain load is being imposed on the table and that too, every hour. The traffic in the morning is relatively low, and that of the night is very high. As per this situation, which is the most advisable utility and how is that utility supposed to be loaded?
What is difference between user and database in teradata?
Explain and compare pros and cons of start schemas?
What happens when a node suffers a downfall?
Explain the new features of teradata?
Explain some differences between mpp and smp?
Highlight the differences between Primary Key and Primary Index.
What is called partitioned primary index (ppi) and discuss the advantages of using it in a query?
Explain the advantages of partitioned primary index in a query?
What is the meaning of Caching in Teradata?
What do high confidence, low confidence and no confidence mean in explain plan?
