Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 6 Answers
- 11122 Views
- Satyam, I also Faced
- E-Mail Answers
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 meant by a Least Cost Plan?
What are the frequently used data types in teradata?
What are default access rights in teradata? What explicit right can be given to a user?
Can you connect multiload from ab initio?
How to identify ppi columns?
While creating table my dba has fallback or no fallback in his ddl. What is that?
Explain the advantages of partitioned primary index in a query?
What is the syntax for case when statement?
What is meant by a Clique?
What is inner join and outer join?
What are the steps to create a data model?
How many types of joins are there in teradata?
What is meant by a Parsing Engine?
Which is faster fastload or multiload?
What is the maximum number of dml can be coded in a multiload script?
