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
- 11135 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
How many types of joins are there in teradata?
What is the command in bteq to check for session settings ?
Explain teradata utilities. What is multiload, fast load, tpump?
What is spool space?
How to Extract data from multiple legacy systems?
What are the various indexes in teradata? Why are they preferred?
What is meant by a Parsing Engine?
Explain some differences between mpp and smp?
What is the use of having index on table?
What can be achieved by using the teradata rdbms?
What is meant by a Highest Cost Plan?
What is a sparse index?
How to eliminate product joins in a teradata sql query?
What do you mean by teradata intellicloud?
What are differences between teradata and ansi session modes in teradata?
