Select distinct from tablename

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

Question Posted / suneel

Answer Posted / suneel

Is This Answer Correct ?

7 Yes

1 No

Please Help Members By Posting Answers For Below Questions

If the PMON is not working then how do you manage and monitor all processes, resources and sessions etc.

2159

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

1061

Explain amp in teradata?

1078

What is meant by Teradata Gateway?

1058

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

1056

Write a program to show the parser component used in teradata?

974

What are the commands to make a new table, change a table and remove a table in teradata?

1132

How can you track login parameters of users in teradata?

1191

How do you determine the number of sessions?

1062

What is meant by a Parsing Engine?

1188

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

1041

What are differences between teradata and ansi session modes in teradata?

1175

How to find duplicates in a table?

1212

What is the purpose of joins in teradata?

1182

What are the various reporting tools in the market?

1068