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 test executive?
Why cant a developer test his own software?
What is internationalization Testing?
'This life cycle model is driven by schedule and budget risks' this statement is best suited for.
HI to all this is dinakar i am planning to write istqb foundation level exam but i dont have the material so any one have material regards that one please send to my id was dinakarmails@gmail.com thanks alot in advance
What is the mission of testing?
Explain the difference between functional and structural testing.
Which review is normally used to evaluate a product to determine its suitability for the intended use and to identify discrepancies?
Which is the current formal world-wide recognized documentation standard?
What Do You Think Is The Main Advantage Of using Test Management tool nowdays?
In practice, which life cycle model may have more, fewer or different levels of development and testing, depending on the project and the software product. For example, there may be component integration testing after component testing, and system integration testing after system testing.
Every One is saying that Documentation is very very importent in Tester's Life.Could any one explain with proper examples..?