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?
- 6 Answers
- 10055 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
In Teradata, what is the significance of UPSERT command?
How do you see a ddl for an existing table?
What are the components used in smp and massively parallel processing (mpp) machines?
How would you load a very large file in teradata in general?
Steps to create a data model?
Differentiate primary key and partition key?
How would you load a very large file in teradata in general? What utility would you use for it? Why?
Briefly explain each of the following terms related to relational database management system (rdbms) – database, tables, columns, row, primary key and foreign key.
How will you solve the problem that occurs during update?
Explain teradata utilities. What is multiload, fast load, tpump?
Difference between star and snowflake schemas?
Can you connect multiload from ab initio?
What is bteq script in teradata?
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 called partitioned primary index (ppi) and discuss the advantages of using it in a query?
