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 glossary of software qa/testing?
In the 7 Stages of the SDLC (Planning, System Analysis, System Design, Development, Testing, Implementation, and Maintenance), WHO are the stakeholders of each stage?
hi everyone i want to download test director,winrunner,qtp latest versions pls help me
What is the objective of regression testing?
what is the difference between QTP 9.1 and ATP 9.2
2 Answers Avantas, Semantic Space,
hi..I am from Pune and i want to take ISTQB.So pls tell me which book i should refer and sample papers?How much time i need to prepare for it?Those who have material pls help me out and mail me at pankaj_r_autela@yahoo.com , And those who are from Pune and have taken this exam ,i vl like to share your knowledge. Thanks in Advance to all of you.. Pankaj
Explain operational testing?
What is fault tree analysis?
Explain ETVX concept?
What is Lun?
Why we go for automated tesing?
What is recovery/error testing?