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 dependency testing?
What are the main key components in Web applications and client and Server applications? (differences)
4 Answers Accenture, Disha Tech, Verisoft,
Explain inputs?
Which of the following is not a Game Genre? a) RTS b) STR c) FTS d) RPG
What r all the cultural barriers u r facing?
I am going for an interview for back end and ui testing. Can smone tell me some important questions?
What are environment variables and explain the use of the same.
What is boundary value?
What is the difference between test matrix and traceability matrix?
What is the model which you follow in your project? Explain it.
What is exhaustive testing?
Explain how to test documents in a project that span across the software development lifecycle?