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
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
- 8 Answers
- 11225 Views
- Satyam, I also Faced
- E-Mail Answers
Answer Posted / pavan
sel case
when m1-m2 >0 and m1-m3 >0 then m1
when m2-m1>0 and m2-m3>0 then m2
when m3-m1>0 and m3-m2 >0 then m3
end as maxmaks,m1,m2,m3,id from ttemp.t3;
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
Mention the procedure via which, we can run Teradata jobs in a UNIX environment.
Hi send me the Teradata dumps to my id rajeshanantha@yahoo.co.in Thanks Rajesh. A
What are the available primary index types in teradata.
How is the teradata different from oracle?
What are default access rights in teradata?
Explain how spool space is used.
How do you determine the number of sessions?
What is a dimension table?
What are the components used in smp and massively parallel processing (mpp) machines?
What are the joins in teradata and how many types of joins are there in teradata?
How do you do backup and recovery in teradata?
My table got locked during mload due to a failed job. What do I do to perform other operations on it?
What are normalization, first normal form, second normal form and third normal form?
What is meant by a Parsing Engine?
What do you mean by fastexport in teradata?
