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 is control chart?
What is the difference between Test strategy and Test plan?
What is Lun masking? Why it is used?
I am going for an interview for back end and ui testing. Can smone tell me some important questions?
What are the preconditions or initial conditions before doing the Automation testing?
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?
At what phase tester role starts?
If a bug is found by the customer after product release, then what cycle is applied to find the cause of that defect
Explain branch testing?
What is a test configuration manager?
What are the advantages of designing tests early in the life cycle?
which is the best institute for testing in hyd?