i have a table like sales....the field are
Prodid Jan(jam month sales)Feb March apr may jun july
1 20 76 50 74 94 93 83
2 30 94 40 94 93 93 02
3 40 90 30 49 94 92 56
4 70 20 30 93 46 35 78
5 23 40 40 39 84 46 57
6 85 30 55 93 46 46 46
7 84 20 65 83 56 57 57
8 10 93 40 93 68 57 36
9 57 30 30 83 67 57 79
10 38 83 40 83 55 68 47
11 35 39 90 94 57 78 47
12 83 89 50 93 79 69 69
i wat ti find the max sales of every product which i want to
load into target table
Answer Posted / guest
thank for ur rly.
But apart from this ans can we any other way?
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What are the various indexes in teradata? How to use them? Why are they preferred?
What is meant by a Clique?
How to view every column and the columns contained in indexes in teradata?
In the Primary Index, what is the score of AMPs that are actively involved?
What is the purpose of upsert command?
What is oltp?
What do you mean by ttu in teradata?
What are the uses of bynets in multi-node systems?
In general, how do you optimze any sql in teradata?
What are the available join types in teradata?
Discuss the advantages of using partitioned primary index in a query?
What is the basic syntax for teradata select statement?
Can you fastexport a field, which is primary key by putting equality on that key?
What is meant by a dispatcher?
What is upsert statement in teradata?