How to delete duplicates records in teradata without any
tables....?
with only one single query,,,?
Answers were Sorted based on User's Feedback
Answer / 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 |
Answer / uma
Select Column_name from table_name group by column_name having count(column_name)>1
| Is This Answer Correct ? | 0 Yes | 0 No |
What are non-functional requirements?
Explain structural testing?
What is pdr - peer design review?
What is total quality management?
How you find the performance of a web application by looking at the values of ?Response Time? and ?Pages Per Second??
Examples where you have worked on your own and as part of a team.
Testing wherein we subject the target of the test, to varying workloads to measure and evaluate the performance behaviors and the ability of the target and the test to continue to function properly under these different workloads?
WHAT ARE THE BUG TRACKING TOOLS USED IN TESTING PROCESS AND WHICH IS BETTER TOOL TO BE USED IN BUG REPORTING ?
Define the notion of transaction and deadlock ?
What is customer (end user)?
What is the difference between Manual Test Plan and the Automated Test Plan?
What is the information that should be covered in test plan?