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 |
IN integration testing tester should knowledge of code or not?
What is bottom-up strategy?
What certifications can a tester of less than 1 yr experience go for? which is the best certification and how many months of preparation is required?
What are the goals in your career as Test Engineer if u join the new compnay
What is control structure testing?
Explain system testing?
WHAT IS MEAN BY OBJECT ORIENTED DESIGN? HOW DOES IT AFFECTS TESTING?
Hi i am urgently in need of the ISTQB sample exam questions by John A Estrella and Maria C Estrella as i am going to take the exam at the end of this month. Please send the ecopy of this book to tselvi83@yahoo.co.in
what is system testing?
What are the maximum no. of devices supported in SCS-1,2 and 3?
What are the technical reviews?
Functional testing?