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
- 10011 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 stored procedure in teradata?
How to run a query in teradata?
What is the difference between teradata and basic rdbms?
Give the sizes of SMALLINT, BYTEINT and INTEGER.
Highlight the limitations of TPUMP Utility.
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 are the functions of a teradata dba?
Highlight the advantages of PPI(Partition Primary Index).
What is the difference between global temporary tables and volatile temporary tables?
What are the different functions included in the server software?
What are the uses of client software involved in teradata?
What is called partitioned primary index (ppi)?
Explain the term 'columns' related to relational database management system?
Steps to create a data model?
How many types of joins are there in teradata?
