Interested to Buy Any Domain ? << Click Here >> for more details...
how to delete duplicate records in multi set table without using any tables
- 2 Answers
- 14679 Views
- Accenture, Nest, South Nests Software Solution, Spiro Solutions, I also Faced
- E-Mail Answers
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
Explain PDE.
What is the opening step in basic teradata query script?
Is multi insert ansi standard?
What do you mean by tpt in teradata?
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 the use of virtual processor connectivity in teradata?
How to write the query . eid enm doj dob i want to display the names who worked more than 25 years .
What is the purpose of using case expression in teradata?
Differentiate primary key and partition key?
What is spool space? Why do you get spool space errors? How do trouble-shoot them?
What is meant by a Highest Cost Plan?
What are the steps involved after the disk manager passes the request?
How you will check the version of teradata?
What are the commands to make a new table, change a table and remove a table in teradata?
In general, how do you optimze any sql in teradata?
