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

What is the use of fallback?

0 Answers  

we have two tables emp,dept.emp has eno,ename,sal and dept has deptno,dname.how to find maxsal of each dept wise.which join used for joining.

5 Answers   Accenture, Cognizant,

In your project what type of issues and errors you facing in Teradata

1 Answers   iGate,

Give some points about Teradata Viewpoint ?

3 Answers   Teradata,

Can we load a Multi set table using MLOAD?

2 Answers  

teradata support to automatically increase the character length or not?

1 Answers  

i have a table like sales....the field are Prodid Jan(jam month sales)Feb March 1 20 76 50 2 30 94 40 3 40 90 30 4 70 20 30 5 23 40 40 6 85 30 55 7 84 20 65 8 10 93 40 9 57 30 30 10 38 83 40 11 35 39 90 12 83 89 50 Now the Question is i want get the max sales of 12 products from the months.hint:for eg I WANT GET 89 for product12... Can any one help me

8 Answers   Satyam,

what is sysdba and sysdbc ? which has high priority ?

0 Answers   Wipro,

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  

Define views in teradata with general syntax.

0 Answers  

Give the sizes of SMALLINT, BYTEINT and INTEGER.

0 Answers  

What is logical data model?

0 Answers