How to delete duplicates records in teradata without any
tables....?
with only one single query,,,?
- 3 Answers
- 6832 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 are the layers of iSCSI Protocol?
How to copy some tables in a DB to another DB in SQL Server
what are the interviews questions for storage domain
Explain structural testing?
What are two formats of WWN defined by the IEEE?
What is loop testing?
What are the maximum no. of devices supported in SCS-1,2 and 3?
What determines the level of risk?
how many types of automation frame works are there?
Can anyone tell me is there any cirtification in Testing like we have SUN cirtification in java,if yes then from where i can get it & which institute offer those cirtification & what is he process
What is error-based testing?
Spot the 5 differences between the two figures
Automation Testing 
