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

what is sysdba and sysdbc ? which has high priority ?

3784

What are the functions of a teradata dba?

1042

What is stored procedure in teradata?

979

Explain Teradata performance tuning and optimization?

1121

How to eliminate product joins in a teradata sql query?

973

Explain teradata architecture?

1045

Explain fastload in teradata?

1062

How to view every column and the columns contained in indexes in teradata?

998

What is the use of stored procedures in teradata?

954

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

1024

If RDBMS is halted what will you do ?

2121

Give a justifiable reason why Multi-load supports NUSI instead of USI.

1101

How to explain project Architecture and flow in teradata interviews?Can please anyone help on this? Am new to teradata.

4339

What are the scenarios in which full table scans occurs?

964

What happens in a conflict? How do you handle that?

1004