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 multi insert?

1108

Highlight the points of differences between the database and user in Teradata.

1159

Explain teradata utilities. What is multiload, fast load, tpump?

1046

Is multi insert ansi standard?

2249

What interface is used to connect to windows based applications?

1167

How will you solve the problem that occurs during update?

1104

List the logical and conditional operators that are used with teradata along with their meanings?

1039

What is a node in teradata?

1049

What are the various indexes in teradata? How to use them? Why are they preferred?

1107

Can we have an unconnected lkp to lookup a db2 record against a teradata record? Doesnt seem to work. I could be wrong

1122

Differentiate database data and data warehouse data?

1161

What are the different table types that are supported by teradata?

1048

What are the various indexes in teradata? How to use them?

1071

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

3537

What are the different table types supported by teradata?

1018