How to delete duplicates records in teradata without any
tables....?
with only one single query,,,?
Answer Posted / 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 |
Post New Answer View All Answers
What are the different types of QA Testing approaches and the process of each?
Which activity in the fundamental test process includes evaluation of the testability of the requirements and system?
In real time how you do the soak testing?
What are the layers of FCOE Protocol?
What is the maximum length of cable supported in SCS-1,2 and 3?
What is recovery/error testing?
What is Lun?
Please Check out and Answer the Questions in Networking section. It's argent.
While monitoring your project what all things you have to consider?
What is pdr - peer design review?
Explain what test plan is?
What is checksheet?
We r developing one Web Site for construction company. In that Web site we have different option like About Us,Contact Us,Home,Sites,Site Map,Search Etc........ and front page of that web application contains 6 different pictures means single page contain 6 pics etc... write Test plan ,Test Scenarios,Test Case ....
What is ansi - american national standards institute?
What is Test Script Planner