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
- 11286 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 the opening step in basic teradata query script?
Can we collect statistics on multiple columns?
How do you determine the number of sessions?
What is a clique?
Syntax for case when statement?
What are the different softwares used with their functions in teradata?
List out teradata data types?
What is the purpose of joins in teradata?
What is meant by a Highest Cost Plan?
What happens in a conflict? How do you handle that?
What are different table types used in teradata?
What is partitioned primary index (ppi)?
How to find duplicates in a table?
When tpump is used instead of multiload?
Explain the advantages of partitioned primary index in a query?
