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

1 20 76 50
2 30 94 40
3 40 90 30
4 70 20 30
5 23 40 40
6 85 30 55
7 84 20 65
8 10 93 40
9 57 30 30
10 38 83 40
11 35 39 90
12 83 89 50
Now the Question is i want get the max sales of 12 products
from the months.hint:for eg I WANT GET 89 for product12...

Can any one help me

Question Posted / rkraju

8 Answers
10967 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;
upto dec we can use similar query to get the max sales from
that sales table i hope u undertand if u have any queries
reach me ravikiran.mca.vadali@gmail.com

Is This Answer Correct ?

0 Yes

0 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

Backup Script was blocked then you are unable to archive the data. how do you analyze it and where do you identify ?

1904

How you will check the version of teradata?

1081

What is the use of stored procedures in teradata?

943

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

1004

what is object level locking ? where do appear this type of locking ?

3449

What do you mean by tpt in teradata?

964

How to write the query . eid enm doj dob i want to display the names who worked more than 25 years .

1728

If the PMON is not working then how do you identify and monitor all the processes, resources and sessions ?

2135

How is MLOAD Client System restarted after execution?

1060

Discuss the advantages of using partitioned primary index in a query?

910

Explain the meaning of Amp?

1038

Highlight the advantages of PPI(Partition Primary Index).

1010

What is multi insert?

986

What is bteq script in teradata?

1083

What is the use of having index on table?

956