How to delete duplicates records in teradata without any
tables....?
with only one single query,,,?
Answer Posted / jain
DELETE FROM table_name A WHERE ROWID > (SELECT min(rowid)
FROM table_name B WHERE A.key_values = B.key_values)
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
Explain how you would allocate a task to team members?
What is oo system testing?
How do you verify the test results and how do you proceed when you do not get the expected results?
Example: A Bank teller determines a need for a new software that displays customer information on her screen. What would using a Waterfall Methodology look like AND what would an Agile Methodology look like in creating this software product?
How u r managing the staff unavailability?
Explain error?
What are the different types of QA Testing approaches and the process of each?
Explain how does a test coverage tool work?
what should be analyzed in laod testing?
Explain regression testing?
Hi, Can any one please provide any links regarding the interview questions for Computer Systems Validation. I have got QA background and looking for a career in CSV in Pharmaceutical Companies. Thanks in advance...
The purpose of which is to allow specific tests to be carried out on a system or network that resembles as closely as possible the environment where the item under test will be used upon release?
Explain metric?
what are all the folders maintained in memory location?
What is your primary role in your project?