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
If I wanted to run a TPump job only once per day - basically working on a file that is produced once per day - how would you set up the parameters for that sort of job ?
What are the various indexes in teradata? How to use them?
What is primary index and secondary index?
What is bteq script in teradata?
What do you mean by parsing?
what are the uses of fact table and dimension table in banking project?
What is the difference between teradata and basic rdbms?
What is difference between user and database in teradata?
What type of indexing mechanism do we need to use for a typical data warehouse?
Explain the term 'database' related to relational database management system?
What are the components provided on node?
What is collect statistics?
What happens when a node suffers a downfall?
Explain the new features of teradata?
What are the uses of client software involved in teradata?