How to delete duplicates records in teradata without any
tables....?
with only one single query,,,?
- 3 Answers
- 7150 Views
- Wipro, I also Faced
- E-Mail Answers
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 the main benefit of designing tests early in the life cycle?
what is conventional Testing? and what is unconventional testing?
For Web Applications what type of tests are you going to do?
Which is the current formal world-wide recognized documentation standard?
Can we do Usability Testing with Automation Testing Tools?????
What is Software Engineering? Please do explain in Brief.
13 Answers Artech, Banyan Soft,
Mention what the meaning of breath testing is?
Test engineer?
How we will do DataBase testing through Qtp application, i know two things 1)Import date from sheet2)Database Check points. But Interviewr asked me How to Run Queries from Qtp Application?Plz Any Body Exlain about Data Base Testing.Urgent.........Advanced Thanks
What are the check points we need to consider while performing Database migration (ex: from oracle 8i to 9i)
Hi All!!Can anyone please suggest some better website to learn Mainframe Testing??Am very much new to Mainframes. Thanks in Advance Nithya
Explain what lcsaj is?
Automation Testing 
