what is the query for retrieve the unique values(not display
the duplicates values) from single table?

Answer Posted / narsimha

select distinct columnsname from table

Is This Answer Correct ?    2 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Why teradata is used?

588


How can bottlenecks be identified?

591


What are the joins in teradata?

582


What is bteq script in teradata?

645


While creating table my dba has fallback or no fallback in his ddl. What is that?

702






How many codd's rules are satisfied by teradata database?

674


How does hashing happens in teradata?

630


What is real time and near real time data warehousing?

683


What are the primary characteristics of the Teradata.

599


What are the various etl tools in the market?

592


What is the particular designated level at which a LOCK is liable to be applied in Teradata?

610


How is MLOAD Client System restarted after execution?

610


How to explain project Architecture and flow in teradata interviews?Can please anyone help on this? Am new to teradata.

3918


How is the teradata different from oracle?

634


How do you define Teradata?

615