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 brainstorming?
What is the information that should be covered in test plan?
could you please send me the ISTQB Material to my mail id ankurcsc@gmail.com
what r transaction synchronistion bugs
In MSBI also we need to write test cases please tell me because iam new to msbi
What is random/monkey testing?
Explain glossary of software qa/testing?
what is the strength of ur company?
Could reviews or inspections be considered part of testing?
What the difference between a 'defect' and a 'failure' in software testing is?
Mention what the main advantages of statement coverage metric of software testing are?
The Following Characterstics posses some XYZ company. * Uses formal standards and policies * Conducts software inspections * Has advanced configuration management and change control * Uses CASE tools * Has a software engineering process group * Gathers metrics on process and quality * Requires that developers have formal software engineering training * Practices continued process improvement Based on aboue , Tell me which CMM Level is the company..? 1. Level 1 - Initial 2. Level 2 - Repeatable 3. Level 3 - Defined 4. Level 4 - Managed 5. Level 5 - Optimizing