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
Can any one explain me the difference between BTEQ and MLOAD,TUMP. All canbe used for same purpose but still differnt methods. why ?
What is the basic syntax for teradata select statement?
What are tpump utility limitations?
What are the different table types supported by teradata?
What is oltp?
What are the different softwares used with their functions in teradata?
How does hashing happens in teradata?
Explain and compare pros and cons of start schemas?
What are the functions of a Parser?
Highlight the differences between Primary Key and Primary Index.
List out teradata data types?
Differentiate primary key and partition key?
Name the five phases that come under MultiLoad Utility.
Highlight a few of the important components of Teradata?
How do you see a ddl for an existing table?