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 is meant by a Least Cost Plan?

1057

How many tables can you join in v2r5?

1063

What is the difference between global temporary tables and volatile temporary tables?

1162

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

1060

What is database exceptions in teradata?

942

What are the various etl tools in the market?

1066

What is the function of parser component in teradata?

1074

what is object level locking ? where do appear this type of locking ?

3487

Difference between inner join and outer join?

1017

What is dimensional modeling?

1078

What is the syntax for case when statement?

1122

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

4361

In the Primary Index, what is the score of AMPs that are actively involved?

1061

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

2155

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?

1190