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
- 9800 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 do high confidence, low confidence and no confidence mean in explain plan?
Name the five phases that come under MultiLoad Utility.
how do we write scripts in unix how to execute scripts in real time anybody please needfull or give me number i will cal u
What is the particular designated level at which a LOCK is liable to be applied in Teradata?
Is it necessary to add? Quit statement after a bteq query when I am calling it in a unix environment?
What are teradata utilities?
If I wanted to run a TPump job only once per day - basically working on a file that is produced once per day - how would you set up the parameters for that sort of job ?
What are the string manipulation operators and functions associated with teradata?
Difference between multiload and tpump?
What is the difference between teradata and oracle?
What are the various indexes in teradata?
What are the different functions performed in development phase?
How to explain project Architecture and flow in teradata interviews?Can please anyone help on this? Am new to teradata.
What do you mean by fastexport in teradata?
Why does varchar occupy 2 extra bytes?
