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
What is the use of having index on table?
What is TPD?
hi frnds i want to learn teradata utilities and teradata dba real time. i have 1+ years of experience in teradata. so i want to go deeply in Tearada. plz let me know at my email id who r best to learn from. im lookng for a realtime guy in HYD or Banglr. Thanks in advance. Rajesh my email-id: rajeshmss87@gmail.com
Explain the advantages of partitioned primary index in a query?
Did you write stored procedures in teradata?
What is called partitioned primary index (ppi) and discuss the advantages of using it in a query?
What are normalization, first normal form, second normal form and third normal form?
A certain load is being imposed on the table and that too, every hour. The traffic in the morning is relatively low, and that of the night is very high. As per this situation, which is the most advisable utility and how is that utility supposed to be loaded?
What does Amp contain and what are all the operations that it performs?
Hi, If anyone has TD 14 Basics dumps or study materials, please share. nirmaaal1991@gmail.com
What are the main components of teradata system?
What are the steps involved after the disk manager passes the request?
Highlight a few of the important components of Teradata?
Explain the new features of teradata?
Highlight the advantages of PPI(Partition Primary Index).