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
- 59514 Views
- I also Faced
- E-Mail Answers
Answer Posted / milind
Nested query method might be required in other databases
how ever in TD we don’t need to follow such a difficult way
to just find out the unique rows.
In TD we have functions like Rank () and Rownum() in the
combination of Qualify, helps you to select out the rows
which you wants to delete.
you can add a condition like ‘Where Rank() > 1’
| Is This Answer Correct ? | 3 Yes | 16 No |
Post New Answer View All Answers
Highlight a few of the important components of Teradata?
What's the difference between timestamp (0) and timestamp (6)?
What are some primary characteristics of teradata?
Can we have an unconnected lkp to lookup a db2 record against a teradata record? Doesnt seem to work. I could be wrong
What are the primary characteristics of the Teradata.
how many modules are there in telecome domain?how to explain the architecture?
What is partitioned primary index (ppi)?
What is meant by a Virtual Disk?
What is a level of granularity of a fact table?
What do you mean by fastexport in teradata?
What is teradata? Also, list out some of the primary characteristics of teradata.
Give a justifiable reason why Multi-load supports NUSI instead of USI.
What are the things to be considered while creating secondary index?
Define views in teradata with general syntax.
Comment whether bottleneck is an error or not.
