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 |
Do you know what the mean of cmm and tmm?
What is a shrink wrapped product?
Which of the following is least like the others? a) Cube b) Sphere c) Pyramid d) Circle
I. Customer focus II. Radical process improvement III. Incremental process improvement IV. Quality control specialists are key V. Assumption of unsound processes VI. Human side of quality VII. Measurement and analysis In the statements above, what are the key elements in the TQM philosophy? 1. I, III, VI, and VII 2. I, II, VI, and VII 3. I, II, IV, and VI 4. III, IV, V, and VII 5. I, III, V, and VI
What is a user friendly document?
What is branch coverage?
i am a PG science(chemistry),now am working test engineer in small organization,now i will decide to move better organization please send model cv and advises
Mention what the meaning of breath testing is?
Is automated testing better than manual testing. If so, why
hi,iam learning testing tools in mindq.i want to put 2+exp. is there any problem with that. tell me what are the Interview questions for experienced peopole. please give me the answer. thanq
What is quality policy?
What is a user interface?