what is the query for retrieve the unique values(not display
the duplicates values) from single table?
- 6 Answers
- 8126 Views
- IBM, I also Faced
- E-Mail Answers
Answer Posted / sarma
Select distinct * from table name
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
Syntax for case when statement?
Explain and compare pros and cons of start schemas?
Explain the most common data types used in teradata?
What type of indexing mechanism do we need to use for a typical data warehouse?
What are the different methods ot loading a dimension table? A fact table etc?
Is multi insert ansi standard?
Describe primary index in teradata?
Explain teradata utilities. What is multiload, fast load, tpump?
What do you mean by fastexport in teradata?
What is a clique?
What do you mean by ttu in teradata?
Give the sizes of SMALLINT, BYTEINT and INTEGER.
What is upsert statement in teradata?
what are the uses of fact table and dimension table in banking project?
What are the primary characteristics of the Teradata.
