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 the different design perspectives used in teradata?

943

how do we write scripts in unix how to execute scripts in real time anybody please needfull or give me number i will cal u

1675

What is real time and near real time data warehousing?

1073

What is meant by a node?

1002

Backup Script was blocked you are unable to archive the data now. how do you analyze it and where do you identify ?

2009

What is primary index and secondary index?

984

What is the difference between union and union all in teradata?

1065

What does sleep function does in fast load?

1074

Explain the term 'database' related to relational database management system?

942

What is meant by a Clique?

1004

Is it necessary to add? Quit statement after a bteq query when I am calling it in a unix environment?

1180

What is bteq utility in teradata?

923

If RDBMS is halted what will you do ?

2115

What is upsert statement in teradata?

1066

While creating table my dba has fallback or no fallback in his ddl. What is that?

1124