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
In the Primary Index, what is the score of AMPs that are actively involved?
What do you mean by fastexport in teradata?
Backup Script was blocked then you are unable to archive the data. how do you analyze it and where do you identify ?
Explain the teradata primary index mechanics in detail with a diagram.
What is real time and near real time data warehousing?
Differentiate database data and data warehouse data?
What are normalization, first normal form, second normal form and third normal form?
What is the function of parser component in teradata?
What are the 5 phases in a multiload utility?
Explain teradata utilities?
How to write the query . eid enm doj dob i want to display the names who worked more than 25 years .
What are teradata utilities?
What are the steps to create a data model?
What is the particular designated level at which a LOCK is liable to be applied in Teradata?
What is the opening step in basic teradata query script?