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 Peer Review in Software Testing?
What can be thought of as being based on the project plan, but with greater amounts of detail?
Hi,can anyone help me with sap testing.how is sap testing done
what r the 2 subdivisions of quality process and where does tesing fit?
What do you mean by automated testing?
A type of functional testing, which investigates the functions relating to the detection of threats, such as virus from malicious outsiders?
Explain what is testing type and what are the commonly used testing type?
What is v- diagram (model)?
What documents will you need to create a test case?
What is test item?
How can you eliminate the product risk in your project?
Explain exhaustive testing?
Your audit indicates that the corporate quality management system did NOT work as it should have. How should this finding be categorized? 1. Minor nonconformance 2. Major nonconformance 3. Deficiency 4. Observation 5. Catastrophic failure
What are the ways of functional testing? Can you give me an example of how to perform Functional testing on a Login Page for example.
What Kinds of Testing should be followed for an web application while Manual Testing . Ie., Regression , Integration , Alpha , Beta , Performance , Stress ,Load , Back End(database)...etc What is the serial way to follow the above Testing Kinds in manual testing of any application. Plz clear my doubt.