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

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

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

In a table can we use primary key in one column and in another column both unique and not null constrains.if yes how?

1114


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

1157


What is the purpose of joins in teradata and what are the available join types?

1019


Highlight all the modes that are present under Confidence Level.

933


what are the day to day activities of teradata DBA ?

5765


Difference between star and snowflake schemas?

1081


What type of indexing mechanism do we need to use for a typical data warehouse?

1095


What are the advantages of teradata?

961


In Teradata, what is the significance of UPSERT command?

1146


What is logical data model?

1158


What are the newly developed features of Teradata?

980


What is the use of virtual processor connectivity in teradata?

958


In the Primary Index, what is the score of AMPs that are actively involved?

1020


How would you load a very large file in teradata in general?

980


What is spool space?

1090