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?
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
Define views in teradata with general syntax.
how many modules are there in telecome domain?how to explain the architecture?
How to Extract data from multiple legacy systems?
What is the meaning of Caching in Teradata?
If a Node is busy what are the steps you can take to avoid ?
List out some of the primary characteristics of teradata.
What do you mean by fastexport in teradata?
Explain the term 'primary key' related to relational database management system?
Explain teradata architecture?
What is the difference between global temporary tables and volatile temporary tables?
How you will check the version of teradata?
What happens in a conflict? How do you handle that?
What type of indexing mechanism do we need to use for a typical data warehouse?
Describe the set operators in teradata.
How to run a query in teradata?