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
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
What are the various reporting tools in the market?
What are the commands to make a new table, change a table and remove a table in teradata?
What are the main components of teradata system?
What is the command in bteq to check for session settings ?
What is the use of fallback?
What are the primary characteristics of the Teradata.
In general, how do you optimze any sql in teradata?
What is the use of having index on table?
Is it necessary to add? Quit statement after a bteq query when I am calling it in a unix environment?
How can we check the version of Teradata that we are using currently?
Explain the term 'tables' related to relational database management system?
Explain how spool space is used.
What is teradata? What are some primary characteristics of teradata?
What do you mean by teradata intelliflex?
If the PMON is not working then how do you identify and monitor all the processes, resources and sessions ?