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 / vaishnavi
Greatest and LEast cannot be used in Teradata. It does not
support those two clauses.
The only option is by using Case Stmnt as given above.
But then if the no.of Column increases(say 200) , its
tedious to write a complex Case stmnt and also it not a
optimised way of writing such queries.
HOping to see more better ans for this question. Also it is
a commonly repeated ques in most of the interviews.
Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
How does hashing happens in teradata?
Is it necessary to add? Quit statement after a bteq query when I am calling it in a unix environment?
Explain the parallel data extension in teradata?
Explain the term 'columns' related to relational database management system?
Explain amp in teradata?
What is a level of granularity of a fact table?
List out teradata data types?
What is teradata?
What is spool space? Why do you get spool space errors? How do trouble-shoot them?
What is the difference between teradata and oracle?
Explain the types of join supports by teradata?
What is meant by Teradata Gateway?
What is the purpose of indexes?
When tpump is used instead of multiload?
What can be achieved by using the teradata rdbms?