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
- 10251 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
While creating table my dba has fallback or no fallback in his ddl. What is that?
List out all forms of LOCKS that are available in Teradata.
how many modules are there in telecome domain?how to explain the architecture?
Comment whether bottleneck is an error or not.
What happens in a conflict? How do you handle that?
What is a sparse index?
why use references rather than pointers in the public api, particularly for arguments which are modified?
What do you mean by tpt in teradata?
What are the steps involved after the disk manager passes the request?
Which is more efficient group by or distinct to find duplicates?
What is primary index and secondary index?
Which is faster fastload or multiload?
Describe the between keyword in teradata?
Explain the term 'database' related to relational database management system?
What is meant by a Virtual Disk?
