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

Answer Posted / tdguy

If its for few columns and small table, use distinct or
group by to fetch only unique values. But for more no of
columns and more no of records in GB, use partition by to
fetch only unique values.

Is This Answer Correct ?    1 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Can any one explain me the difference between BTEQ and MLOAD,TUMP. All canbe used for same purpose but still differnt methods. why ?

3134


What is the basic syntax for teradata select statement?

669


What are tpump utility limitations?

721


What are the different table types supported by teradata?

612


What is oltp?

649






What are the different softwares used with their functions in teradata?

659


How does hashing happens in teradata?

713


Explain and compare pros and cons of start schemas?

641


What are the functions of a Parser?

690


Highlight the differences between Primary Key and Primary Index.

710


List out teradata data types?

636


Differentiate primary key and partition key?

654


Name the five phases that come under MultiLoad Utility.

667


Highlight a few of the important components of Teradata?

669


How do you see a ddl for an existing table?

667