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
- 11128 Views
- Satyam, I also Faced
- E-Mail Answers
Answer Posted / rkraju
hi.,the query is
>>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;
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;
like this u can find max sal upto dec .,i hope this query
fulfill ur req.,
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
What are the various indexes in teradata? Why are they preferred?
Mention a few of the ETL tools that come under Teradata.
What is the purpose of indexes?
If RDBMS is halted what will you do ?
How would you load a very large file in teradata in general?
Explain and compare pros and cons of start schemas?
What is the purpose of using case expression in teradata?
What is meant by a Highest Cost Plan?
if collect stats but it show low confidence why?
How do you verify a complicated sql?
What are normalization, first normal form, second normal form and third normal form?
What do you mean by teradata intelliflex?
What is meant by a Least Cost Plan?
What are the advantages of teradata?
What is spool space? Why do you get spool space errors? How do trouble-shoot them?
