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
- 59947 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
Explain the meaning of Amp?
What are the newly developed features of Teradata?
What is called partitioned primary index (ppi) and discuss the advantages of using it in a query?
What do you mean by teradata sql assistant?
What are the steps involved in the process flow of the sql statement through channel attached system?
what is sysdba and sysdbc ? which has high priority ?
What is meant by a node?
What is the difference between teradata and oracle?
Explain the term 'row' related to relational database management system?
What are the main components of teradata system?
What are the commands to make a new table, change a table and remove a table in teradata?
What are types of partition primary index (ppi) in teradata?
What are the various indexes in teradata? How to use them? Why are they preferred?
What is upsert statement in teradata?
Difference between multiload and tpump?
