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
What is basic teradata query language?
Why managing the data is important?
What are the functions performed by bynet?
What are the functions involved in shared information architecture?
Can you connect multiload from ab initio?
How to find duplicates in a table?
What is meant by a Virtual Disk?
Highlight a few of the advantages that ETL tools have over Teradata.
What is meant by a node?
Explain the meaning of Amp?
What are the different table types that are supported by teradata?
What are teradata utilities?
What is meant by a Channel Driver?
What do you mean by teradata sql assistant?
What is called partitioned primary index (ppi)?