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
- 10961 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
Discuss the advantages of using partitioned primary index in a query?
Why is the case expression used in teradata?
How many codd's rules are satisfied by teradata database?
What are the different methods ot loading a dimension table? A fact table etc?
What is a sparse index?
What is spool space and when running a job if it reaches the maximum spool space how you solve the problem?
How to find duplicates in a table?
What are the available join types in teradata?
If a Node is busy what are the steps you can take to avoid ?
What is TPD?
If RDBMS is halted what will you do ?
Explain the most common data types used in teradata?
How would you load a very large file in teradata in general?
What do you mean by ttu in teradata?
In general, how do you optimze any sql in teradata?
