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
- 10869 Views
- Satyam, I also Faced
- E-Mail Answers
Answer Posted / rkraju
select case when jan>feb and jan>mar and jan> apr and jan>
may and jan>jun then
jan else (case when feb>jan and feb>mar and feb>apr and
feb>may and feb>jun then
feb else (case when mar>jan and mar>feb and mar>apr and
mar>may and mar>jun then
mar else (case when apr>jan and apr>feb and apr>mar and
apr>may and apr>jun then
apr else (case when may>jan and may>feb and may>apr and
may>mar and may>jun then
may else (case when jun>jan and jun>feb and jun>mar and
jun>apr and jun>may then
jun end)end)end)end)end)end from sales;
i hope this ans fulfill ur req.,
| 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
Explain the parallel data extension in teradata?
How do you set the session mode parameters in bteq?
What is node? How many nodes and amps used in your previous project?
What are the string manipulation operators and functions associated with teradata?
What is meant by a Parsing Engine?
What do you mean by teradata intelliflex?
What is multi insert?
What is the use of fallback?
Explain the meaning of Amp?
What is the purpose of joins in teradata?
What are the steps involved in the process flow of the sql statement through channel attached system?
How to write the query . eid enm doj dob i want to display the names who worked more than 25 years .
What are different table types used in teradata?
Why are oltp database designs not generally a good idea for a data warehouse?
