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

Explain the advantages of partitioned primary index in a query?

1009

What is spool space and when running a job if it reaches the maximum spool space how you solve the problem?

1096

Why does varchar occupy 2 extra bytes?

1168

what is sysdba and sysdbc ? which has high priority ?

3813

What are the components used in smp and massively parallel processing (mpp) machines?

1042

What is called partitioned primary index (ppi)?

1000

What is the purpose of indexes?

1044

What are the 5 phases in a multiload utility?

1018

If RDBMS is halted what will you do ?

2141

What are the things to be considered while creating secondary index?

1078

What is TPD?

1354

Explain teradata architecture in detail with a diagram.

1093

During the Display time, how is the sequence generated by Teradata?

1035

What are the components provided on node?

1020

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

1139