what is the query for retrieve the unique values(not display
the duplicates values) from single table?
- 6 Answers
- 8124 Views
- IBM, I also Faced
- E-Mail Answers
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
What are default access rights in teradata?
What is TPD?
In general, how do you optimze any sql in teradata?
What is teradata and why it is used?
What are the frequently used data types in teradata?
What happens when a node suffers a downfall?
Backup Script was blocked you are unable to archive the data now. how do you analyze it and where do you identify ?
Define views in teradata with general syntax.
Differentiate primary key and partition key?
i learn teradata,it is so intersting,now i want teradata certifications ,so any 1 help me to get teradata certifications TD 12 ? email:kdcrazyy@gmail.com
What is bteq utility in teradata?
What is bteq script in teradata?
How will you solve the problem that occurs during update?
Steps to create a data model?
Describe primary index in teradata. And what are the available primary index types?
