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,,,?

Answer Posted / 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       View All Answers


Please Help Members By Posting Answers For Below Questions

Which one of the following activities is the most efficient and most cost effective at identifying defects? 1. Prototyping 2. Unit test 3. Beta test 4. Design/code inspection 5. Risk analysis

2082


Share 2 high complexity and 2 low complexity test cases for a coke vending (ATM) machine.

1074


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

1900


Explain the term bug.

1196


What are the types of defects?

1117


What is oo function testing?

1056


Explain the requirements?

1107


What is CCB and MTBF, why should we use this.

2255


Who is responsible for document all the issues, problems and open point that were identified during the review meeting

1464


Explain end-to-end testing?

1090


HOW TO PERFORM DATABASE TESTING

2190


What is closed box testing?

1136


What is difference between Agile and V model? Explain

2311


how i find swing lenth of probe ?

2174


What is v&v?

1089