select case when jan>feb and jan>mar and jan> apr and jan> may

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

Question Posted / rkraju

6 Answers
10975 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

Please Help Members By Posting Answers For Below Questions

What are the different design perspectives used in teradata?

953

Which is faster fastload or multiload?

1061

What is the purpose of upsert command?

1116

Highlight all the modes that are present under Confidence Level.

942

List out some of the primary characteristics of teradata.

940

How can we check the version of Teradata that we are using currently?

1038

What is spool space? Why do you get spool space errors?

973

What are the components used in smp and massively parallel processing (mpp) machines?

1025

What is spool space? Why do you get spool space errors? How do trouble-shoot them?

954

What is the use of teradata system software?

1007

What are the joins in teradata?

946

What is a sparse index?

1041

What is teradata and why it is used?

1047

Can we collect statistics on table level?

1003

What does Amp contain and what are all the operations that it performs?

972