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?
- 3 Answers
- 5938 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
What is the difference between teradata and oracle?
How is the teradata different from oracle?
What is the use of fallback?
any one answer me how they can analyzing the project using data ware housing?
Explain teradata architecture in detail with a diagram.
What is smp and mpp platforms?
What does sleep function does in fast load?
What is bteq script in teradata?
What are the different functions included in the server software?
Which is more efficient group by or distinct to find duplicates?
Name the five phases that come under MultiLoad Utility.
What are the functions of a Parser?
What is meant by a node?
If Fast Load Script fails and only the error tables are made available to you, then how will you restart?
Syntax for case when statement?
