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 are default access rights in teradata? What explicit right can be given to a user?

1143

What is the purpose of indexes?

1126

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

1122

What is teradata? Also, list out some of the primary characteristics of teradata.

1118

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

1148

Explain fallback in teradata?

1096

What are the uses of client software involved in teradata?

1035

Explain teradata architecture in detail with a diagram.

1163

Explain the most common data types used in teradata?

1120

What is logical data model?

1255

What are the enhanced features in teradata v2r5 and v2r6?

1182

What is spool space? Why do you get spool space errors? How do trouble-shoot them?

1037

What is a level of granularity of a fact table?

1219

Highlight all the modes that are present under Confidence Level.

1007

What are the newly developed features of Teradata?

1081