use distinct or group by to avoid duplicates in teradata.

one table have
input
no name
10 rao
20 siva
30 srinu
10 rao
i want to ouput like this way
no name
20 siva
30 srinu
10 rao
how it posible in only sql server query?not oracle?

Question Posted / tdguy

3 Answers
7269 Views
IBM, I also Faced
E-Mail Answers

Answer Posted / tdguy

use distinct or group by to avoid duplicates in teradata.

Is This Answer Correct ?

1 Yes

0 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

Describe the set operators in teradata.

1050

Difference between star and snowflake schemas?

1249

What is upsert statement in teradata?

1194

Explain the most common data types used in teradata?

1125

Can we have two time dimensions in a schema(either star or snow flake)? For ex if we want joining date of employee and if we want today's sales with time whether can we have two time dimensions for accommodating above tasks?

2195

What is the use of fallback?

1038

Name the five phases that come under MultiLoad Utility.

1032

Mention a few of the ETL tools that come under Teradata.

1134

Is multi insert ansi standard?

2254

List the logical and conditional operators that are used with teradata along with their meanings?

1042

How do you see a ddl for an existing table?

1061

What is meant by a Channel Driver?

1334

What interface is used to connect to windows based applications?

1176

How do you define Teradata?

1087

What is real time and near real time data warehousing?

1161