what is the query for retrieve the unique values(not display
the duplicates values) from single table?
Answer Posted / sarma
Select distinct * from table name
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
In a table can we use primary key in one column and in another column both unique and not null constrains.if yes how?
What is the difference between fastload and multiload? Which one is faster?
What is the purpose of joins in teradata and what are the available join types?
Highlight all the modes that are present under Confidence Level.
what are the day to day activities of teradata DBA ?
Difference between star and snowflake schemas?
What type of indexing mechanism do we need to use for a typical data warehouse?
What are the advantages of teradata?
In Teradata, what is the significance of UPSERT command?
What is logical data model?
What are the newly developed features of Teradata?
What is the use of virtual processor connectivity in teradata?
In the Primary Index, what is the score of AMPs that are actively involved?
How would you load a very large file in teradata in general?
What is spool space?