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
- 5908 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 are the day to day activities of teradata DBA ?
How to identify ppi columns?
Explain fastload in teradata?
What do high confidence, low confidence and no confidence mean in explain plan?
Explain some differences between mpp and smp?
How do you verify a complicated sql?
What is meant by Teradata Gateway?
Describe primary index in teradata?
How many sessions of MAX is PE capable of handling at a particular time?
What are the primary characteristics of the Teradata.
What are the various reporting tools in the market?
what is object level locking ? where do appear this type of locking ?
What are the design features involved in teradata?
What is the purpose of joins in teradata and what are the available join types?
Hi, If anyone has TD 14 Basics dumps or study materials, please share. nirmaaal1991@gmail.com
