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...

  1. Categories >> Software >> Data Warehouse >> Teradata
  2. Suggest New Category

what is the query for retrieve the unique values(not display
the duplicates values) from single table?

Question Posted / sarma

Answer Posted / sarma

Select distinct * from table name

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Give a justifiable reason why Multi-load supports NUSI instead of USI.

1150

What are the various reporting tools in the market?

1055

Explain teradata architecture?

1081

List out some of the primary characteristics of teradata.

978

What is the difference between fastload and multiload? Which one is faster?

1214

Explain teradata utilities?

1032

How do you define Teradata?

1029

What are the string manipulation operators and functions associated with teradata?

1077

What is the particular designated level at which a LOCK is liable to be applied in Teradata?

1038

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

1039

What is a dimension table?

1049

How to identify ppi columns?

1173

Why does varchar occupy 2 extra bytes?

1182

What is the use of fallback?

989

Why teradata is used?

995