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
- 10878 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
Can we have an unconnected lkp to lookup a db2 record against a teradata record? Doesnt seem to work. I could be wrong
How teradata makes sure that there are no duplicate rows being inserted when its a set table?
Define views in teradata with general syntax.
What is spool space and when running a job if it reaches the maximum spool space how you solve the problem?
What are the multiload utility limitations?
What are the functions of a Parser?
Give a justifiable reason why Multi-load supports NUSI instead of USI.
What do you mean by ttu in teradata?
What are some commonly used bteq scripts?
What is the use of stored procedures in teradata?
What are the different table types supported by teradata?
Why managing the data is important?
Explain the term 'columns' related to relational database management system?
In Teradata, how do we Generate Sequence?
Define views in teradata with syntax.
