what is the query for retrieve the unique values(not display
the duplicates values) from single table?
- 6 Answers
- 8996 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 the functions performed by bynet?
hi frnds i want to learn teradata utilities and teradata dba real time. i have 1+ years of experience in teradata. so i want to go deeply in Tearada. plz let me know at my email id who r best to learn from. im lookng for a realtime guy in HYD or Banglr. Thanks in advance. Rajesh my email-id: rajeshmss87@gmail.com
Explain the term 'primary key' related to relational database management system?
Highlight the points of differences between the database and user in Teradata.
What is the use of virtual processor connectivity in teradata?
How do you set the session mode parameters in bteq?
What is the meaning of Caching in Teradata?
Describe primary index in teradata?
What are the newly developed features of Teradata?
Explain the most common data types used in teradata?
Can we collect statistics on multiple columns?
What is a sparse index?
Explain teradata architecture in detail with a diagram.
What is meant by a Channel Driver?
Explain how spool space is used.
