what is the query for retrieve the unique values(not display
the duplicates values) from single table?
- 6 Answers
- 9002 Views
- IBM, I also Faced
- E-Mail Answers
Answer Posted / narsimha
select distinct columnsname from table
| Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
What is the purpose of joins in teradata?
What is database exceptions in teradata?
Can you connect multiload from ab initio?
What is real time and near real time data warehousing?
What is the use of fallback?
What is the syntax for case when statement?
Is multi insert ansi standard?
How to view every column and the columns contained in indexes in teradata?
What is inner join and outer join?
What are the different methods ot loading a dimension table? A fact table etc?
What is a dimension table?
What is meant by a dispatcher?
How do you do backup and recovery in teradata?
What are some commonly used bteq scripts?
How do you create tables? Exact syntax, and create profiles, users in teradata?
