what is the query for retrieve the unique values(not display
the duplicates values) from single table?
- 6 Answers
- 8541 Views
- IBM, I also Faced
- E-Mail Answers
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
What are the 5 phases in a multiload utility?
How to eliminate product joins in a teradata sql query?
Highlight the advantages of PPI(Partition Primary Index).
Differentiate database data and data warehouse data?
Give the sizes of SMALLINT, BYTEINT and INTEGER.
What are the design features involved in teradata?
Where is teradata rdbms used?
What are the components used in smp and massively parallel processing (mpp) machines?
Mention a few of the ETL tools that come under Teradata.
What are default access rights in teradata? What explicit right can be given to a user?
What does Amp contain and what are all the operations that it performs?
Describe primary index in teradata. And what are the available primary index types?
Let us say there is a file that consists of 100 records out of which we need to skip the first and the last 20 records. What will the code snippet?
Explain teradata architecture in detail with a diagram.
Can you fastexport a field, which is primary key by putting equality on that key?
