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 |
What is differnce between Error code and Error Level in Bteq
What is the difference between fastload and multiload?
teradata support to automatically increase the character length or not?
Explain about Skew Factor?
What is the purpose of upsert command?
Explain the new features of teradata?
What is the maximum number of dml can be coded in a multiload script?
What is bteq script in teradata?
On which column will you take primary index???
How to identify ppi columns?
Difference between stored procedure and macro?
What is upsert statement in teradata?