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

IN integration testing tester should knowledge of code or not?

0 Answers   Cognizant,


What is bottom-up strategy?

0 Answers  


What certifications can a tester of less than 1 yr experience go for? which is the best certification and how many months of preparation is required?

1 Answers  


What are the goals in your career as Test Engineer if u join the new compnay

0 Answers   Cap Gemini,


What is control structure testing?

0 Answers  


Explain system testing?

0 Answers  


WHAT IS MEAN BY OBJECT ORIENTED DESIGN? HOW DOES IT AFFECTS TESTING?

1 Answers   Wipro,


Hi i am urgently in need of the ISTQB sample exam questions by John A Estrella and Maria C Estrella as i am going to take the exam at the end of this month. Please send the ecopy of this book to tselvi83@yahoo.co.in

0 Answers  


what is system testing?

0 Answers  


What are the maximum no. of devices supported in SCS-1,2 and 3?

0 Answers  


What are the technical reviews?

1 Answers   TCS,


Functional testing?

0 Answers  


Categories