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 duplicate records in multi set table without using any tables

Answer Posted / nidhi

make use of Qualify, though it wont delete duplicate..but
also wont show u duplicate as well in answer set.

Is This Answer Correct ?    5 Yes 7 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Backup Script was blocked you are unable to archive the data now. how do you analyze it and where do you identify ?

2048


Mention a few of the ETL tools that come under Teradata.

1072


What are the primary characteristics of the Teradata.

1136


Explain amp in teradata?

1070


What are the functions of a Parser?

1095


How teradata makes sure that there are no duplicate rows being inserted when its a set table?

980


Describe primary index in teradata?

995


What is the basic syntax for teradata select statement?

1030


What are the available primary index types?

1208


Explain teradata architecture?

1081


What are aggregate tables? How do you design them using teradata?

1162


Highlight all the modes that are present under Confidence Level.

969


What are the different functions performed in development phase?

1073


Explain the term 'database' related to relational database management system?

977


In general, how do you optimze any sql in teradata?

1039