what is the query for retrieve the unique values(not display
the duplicates values) from single table?
Answers were Sorted based on User's Feedback
Answer / 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 |
Answer / mohith.dmdw
select distinct <column_name> from <table_name>;
Is This Answer Correct ? | 0 Yes | 0 No |
"pravalli nagireddy" record is there in address column but i want display only 'nagireddy' from the main string what is query for that pls tell me
Difference between Teradata V2R5 and Teradata V12 versions?
What type of indexing mechanism do we need to use for a typical data warehouse?
How to Skip or Get first and Last Record from Flat File through MultiLoad and TPUMP Utility?
What is meant by a Least Cost Plan?
How does hashing happens in teradata?
what are the day to day activities of teradata DBA ?
What are the various reporting tools in the market?
Why do you get spool space errors? How do trouble-shoot them?
Explain the new features of teradata?
What happens when a node suffers a downfall?
In the Primary Index, what is the score of AMPs that are actively involved?