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 / mohith.dmdw

select distinct <column_name> 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

Which is faster fastload or multiload?

1053


What is primary index and secondary index?

985


What are the steps involved after the disk manager passes the request?

1051


What are the various indexes in teradata?

990


What are the advantages of teradata?

962


Is multi insert ansi standard?

2157


When tpump is used instead of multiload?

1061


What is teradata and why it is used?

1031


List out all forms of LOCKS that are available in Teradata.

929


How to identify ppi columns?

1119


How to find duplicates in a table?

1157


What are the functions of a Parser?

1049


Can we have two time dimensions in a schema(either star or snow flake)? For ex if we want joining date of employee and if we want today's sales with time whether can we have two time dimensions for accommodating above tasks?

2057


Describe the set operators in teradata.

963


Why teradata is used?

949