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
- 9782 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 happens in a conflict? How do you handle that?
In Teradata, how do we Generate Sequence?
While creating table my dba has fallback or no fallback in his ddl. What is that?
Difference between star and snowflake schemas?
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 joins in teradata?
In general, how do you optimze any sql in teradata?
Explain some differences between mpp and smp?
What are tpump utility limitations?
What is meant by a Clique?
Can we have two time dimensions in a schema(either star or snow flake)? For ex if we want joining date of employee and if we want today's sales with time whether can we have two time dimensions for accommodating above tasks?
What is a sparse index?
Is multi insert ansi standard?
What is the difference between fastload and multiload? Which one is faster?
What is the use of having index on table?
