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
- 59048 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
Write a program to show the parser component used in teradata?
Give the sizes of SMALLINT, BYTEINT and INTEGER.
What do high confidence, low confidence and no confidence mean in explain plan?
Why managing the data is important?
What do you mean by tpt in teradata?
What is logical data model?
Let us say there is a file that consists of 100 records out of which we need to skip the first and the last 20 records. What will the code snippet?
Where is teradata rdbms used?
How to write the query . eid enm doj dob i want to display the names who worked more than 25 years .
Describe the set operators in teradata.
What are the available primary index types in teradata.
What are the different methods ot loading a dimension table? A fact table etc?
What are the enhanced features in teradata v2r5 and v2r6?
What happens in a conflict? How do you handle that?
What does Amp contain and what are all the operations that it performs?
