Answer / suneel

Select distinct from tablename

Answer / narsimha

select distinct columnsname from table

Answer / nasimha

above answer is correct

Answer / tdguy

If its for few columns and small table, use distinct or
group by to fetch only unique values. But for more no of
columns and more no of records in GB, use partition by to
fetch only unique values.

Answer / mohith.dmdw

select distinct <column_name> from <table_name>;

Answer / sarma

Select distinct * from table name

Hi send me the Teradata dumps to my id rajeshanantha@yahoo.co.in Thanks Rajesh. A

0 Answers  

Explain the types of join supports by teradata?

0 Answers  

How do you determine the number of sessions?

0 Answers  

What are the various indexes in teradata? Why are they preferred?

0 Answers  

what is use of fload loading into set table?

2 Answers   IBM,

what is a multi statement request in TD? what is the diif b/w V2R5 & TD12? what is the diff b/w MACRO & STORED PROCEDURE?

3 Answers   HCL,

Can we take collect stats on Dervied Tables and Volitable tables, What is Golabal Temporary table what is the use of this Golabal Temporary table ,When we create any kind table in Teradata it will show in Golabal Temporary table

6 Answers   IBM,

can i call router is a passive transformation

2 Answers  

Describe primary index in teradata. And what are the available primary index types?

0 Answers  

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?

0 Answers  

A Query was run fine earlier. It is not running properly now. what are proactive steps you can take as a dba ?

1 Answers  

What EXPLAIN does in Teradata, what is High confidence, Low confidence and No confidence.. And How we improve the query performance .

5 Answers   Accenture,