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 / suneel

Select distinct from tablename

Is This Answer Correct ?    7 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What are the commands to make a new table, change a table and remove a table in teradata?

1132


why use references rather than pointers in the public api, particularly for arguments which are modified?

1006


What are some commonly used bteq scripts?

1009


Explain and compare pros and cons of start schemas?

1065


What is collect statistics?

999


What is the purpose of joins in teradata?

1189


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

1169


What is bteq utility in teradata?

974


What is the command in bteq to check for session settings ?

1180


What is the purpose of using case expression in teradata?

1017


Discuss the advantages of using partitioned primary index in a query?

954


Did you write stored procedures in teradata?

1132


What is meant by a Virtual Disk?

1136


What is database exceptions in teradata?

952


What is the use of stored procedures in teradata?

1004