what is the query for retrieve the unique values(not display
the duplicates values) from single table?
Answer Posted / mohith.dmdw
select distinct <column_name> from <table_name>;
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
Which is faster fastload or multiload?
What is primary index and secondary index?
What are the steps involved after the disk manager passes the request?
What are the various indexes in teradata?
What are the advantages of teradata?
Is multi insert ansi standard?
When tpump is used instead of multiload?
What is teradata and why it is used?
List out all forms of LOCKS that are available in Teradata.
How to identify ppi columns?
How to find duplicates in a table?
What are the functions of a Parser?
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?
Describe the set operators in teradata.
Why teradata is used?