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
- 59581 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
What are the available join types in teradata?
What exactly do you know about catching in teradata?
how do you manage the production space. what are the proactive methods you can take ?
What does Amp contain and what are all the operations that it performs?
What are the various reporting tools in the market?
How do you verify a complicated sql?
What is the use of teradata system software?
When tpump is used instead of multiload?
List out some of the primary characteristics of teradata.
What can be achieved by using the teradata rdbms?
What is meant by a Channel Driver?
how can we analyze the locks ?
Explain and compare pros and cons of start schemas?
Explain parsing engine in teradata?
What are the primary characteristics of the Teradata.
