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
- 9830 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 is primary index and secondary index?
What are the 5 phases in a multiload utility?
Define views in teradata with syntax.
Difference between multiload and tpump?
What type of indexing mechanism do we need to use for a typical data warehouse?
What are the different design perspectives used in teradata?
Explain vproc in teradata?
What are the available primary index types in teradata.
Explain the term 'tables' related to relational database management system?
In BTEQ, how are the session-mode parameters being set?
What are the steps involved in the process flow of the sql statement through channel attached system?
What happens in a conflict? How do you handle that?
What is oltp?
why use references rather than pointers in the public api, particularly for arguments which are modified?
How to identify ppi columns?
