Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...


How to delete duplicates records in teradata without any
tables....?
with only one single query,,,?

Answers were Sorted based on User's Feedback



How to delete duplicates records in teradata without any tables....? with only one single query,,,..

Answer / suganya

SELECT DISTINCT column_name(s)
FROM table_name

Is This Answer Correct ?    9 Yes 2 No

How to delete duplicates records in teradata without any tables....? with only one single query,,,..

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

How to delete duplicates records in teradata without any tables....? with only one single query,,,..

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

Post New Answer

More Testing AllOther Interview Questions

What are non-functional requirements?

5 Answers   Ford, Siemens,


Explain structural testing?

0 Answers  


What is pdr - peer design review?

0 Answers  


What is total quality management?

0 Answers  


How you find the performance of a web application by looking at the values of ?Response Time? and ?Pages Per Second??

1 Answers  


Examples where you have worked on your own and as part of a team.

0 Answers   Infosys,


Testing wherein we subject the target of the test, to varying workloads to measure and evaluate the performance behaviors and the ability of the target and the test to continue to function properly under these different workloads?

0 Answers  


WHAT ARE THE BUG TRACKING TOOLS USED IN TESTING PROCESS AND WHICH IS BETTER TOOL TO BE USED IN BUG REPORTING ?

2 Answers  


Define the notion of transaction and deadlock ?

1 Answers  


What is customer (end user)?

0 Answers  


What is the difference between Manual Test Plan and the Automated Test Plan?

0 Answers  


What is the information that should be covered in test plan?

0 Answers  


Categories