select distinct <column_name> from <table

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

Question Posted / mohith.dmdw

Answer Posted / mohith.dmdw

select distinct <column_name> from <table_name>;

Is This Answer Correct ?

0 Yes

0 No

Please Help Members By Posting Answers For Below Questions

What is meant by a Virtual Disk?

1136

Difference between star and snowflake schemas?

1152

What is a dimension table?

1063

In Teradata, what is the significance of UPSERT command?

1234

How do you set the session mode parameters in bteq?

1102

In BTEQ, how are the session-mode parameters being set?

1143

What do you mean by ttu in teradata?

1033

What is bteq utility in teradata?

974

What does sleep function does in fast load?

1139

What does Amp contain and what are all the operations that it performs?

999

When tpump is used instead of multiload?

1105

Explain the parallel data extension in teradata?

1094

What are different table types used in teradata?

1041

What is meant by a Parsing Engine?

1188

Explain the new features of teradata?

1045