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 multi insert?
Highlight the points of differences between the database and user in Teradata.
Explain teradata utilities. What is multiload, fast load, tpump?
Is multi insert ansi standard?
What interface is used to connect to windows based applications?
How will you solve the problem that occurs during update?
List the logical and conditional operators that are used with teradata along with their meanings?
What is a node in teradata?
What are the various indexes in teradata? How to use them? Why are they preferred?
Can we have an unconnected lkp to lookup a db2 record against a teradata record? Doesnt seem to work. I could be wrong
Differentiate database data and data warehouse data?
What are the different table types that are supported by teradata?
What are the various indexes in teradata? How to use them?
what is object level locking ? where do appear this type of locking ?
What are the different table types supported by teradata?