Select distinct * from table name

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

Question Posted / sarma

Answer Posted / sarma

Is This Answer Correct ?

0 Yes

0 No

Please Help Members By Posting Answers For Below Questions

What is multi insert?

1108

What are the frequently used data types in teradata?

1131

Let us say there is a file that consists of 100 records out of which we need to skip the first and the last 20 records. What will the code snippet?

1257

Mention the procedure via which, we can run Teradata jobs in a UNIX environment.

1037

How many tables can you join in v2r5?

1116

What are the various indexes in teradata?

1094

Different phases of multiload?

1063

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

1039

why use references rather than pointers in the public api, particularly for arguments which are modified?

1053

What is the difference between teradata and basic rdbms?

1072

What exactly do you know about catching in teradata?

1078

In Teradata, what is the significance of UPSERT command?

1314

What are the different softwares used with their functions in teradata?

1060

Difference between inner join and outer join?

1082

What is the use of teradata system software?

1087