what is the query for retrieve the unique values(not display
the duplicates values) from single table?
- 6 Answers
- 9069 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
Explain the teradata primary index mechanics in detail with a diagram.
Briefly explain each of the following terms related to relational database management system (rdbms) – database, tables, columns, row, primary key and foreign key.
What are the various indexes in teradata? Why are they preferred?
What type of indexing mechanism do we need to use for a typical data warehouse?
what are the day to day activities of teradata DBA ?
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
How to run a query in teradata?
Explain BYNET.
Discuss the advantages of using partitioned primary index in a query?
Why is the case expression used in teradata?
What are the frequently used data types in teradata?
Different phases of multiload?
why use references rather than pointers in the public api, particularly for arguments which are modified?
In Teradata, how do we Generate Sequence?
What are the different methods ot loading a dimension table? A fact table etc?
