how to delete duplicate records in multi set table without using any tables
Answer Posted / nidhi
make use of Qualify, though it wont delete duplicate..but
also wont show u duplicate as well in answer set.
Is This Answer Correct ? | 5 Yes | 7 No |
Post New Answer View All Answers
how do you manage the production space. what are the proactive methods you can take ?
What are the steps to create a data model?
What are the various indexes in teradata? Why are they preferred?
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?
What is partitioned primary index (ppi)?
Why is the case expression used in teradata?
Explain the term 'primary key' related to relational database management system?
List out teradata data types?
What are the different functions performed in development phase?
What is dimensional modeling?
What is bteq script in teradata?
What are differences between teradata and ansi session modes in teradata?
What tools would you use for that?
Can we have two time dimensions in a schema(either star or snow flake)? For ex if we want joining date of employee and if we want today's sales with time whether can we have two time dimensions for accommodating above tasks?
What is spool space? Why do you get spool space errors?