select distinct columnsname from table

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

Question Posted / narsimha

Answer Posted / narsimha

Is This Answer Correct ?

2 Yes

0 No

Please Help Members By Posting Answers For Below Questions

What is meant by a Clique?

1063

Explain amp in teradata?

1083

Comment whether bottleneck is an error or not.

1156

Why are oltp database designs not generally a good idea for a data warehouse?

1056

What are the various reporting tools in the market?

1069

What do you mean by fastexport in teradata?

999

How do you create tables? Exact syntax, and create profiles, users in teradata?

1032

Explain the most common data types used in teradata?

1069

How to eliminate product joins in a teradata sql query?

1029

Explain some differences between mpp and smp?

1099

what is object level locking ? where do appear this type of locking ?

3497

What are different table types used in teradata?

1041

How teradata makes sure that there are no duplicate rows being inserted when its a set table?

986

Mention a few of the ETL tools that come under Teradata.

1079

Discuss the advantages of using partitioned primary index in a query?

952