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
How to explain project Architecture and flow in teradata interviews?Can please anyone help on this? Am new to teradata.
What is spool space?
Highlight the advantages of PPI(Partition Primary Index).
how many modules are there in telecome domain?how to explain the architecture?
How to write the query . eid enm doj dob i want to display the names who worked more than 25 years .
Explain some differences between mpp and smp?
Explain the meaning of Amp?
What are the available join types in teradata?
What do you mean by caching in teradata?
Explain the new features of teradata?
How many codd's rules are satisfied by teradata database?
What is difference between user and database in teradata?
What are the functions involved in shared information architecture?
How do you see a ddl for an existing table?
Explain PDE.