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 / rkraju
HI,
>>THE QUERY IS
>>SELECT CASE WHEN JAN>FEB AND JAN>MAR THEN JAN ELSE (CASE
WHEN FEB>JAN AND FEB>M
R THEN FEB ELSE MAR END) END FROM SALES;
Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What is node? How many nodes and amps used in your previous project?
Hi Friends, Please send me Teradata Materials for certifications Thanks in advance !!
What is difference between user and database in teradata?
Explain some differences between mpp and smp?
How does hashing happens in teradata?
What are aggregate tables? How do you design them using teradata?
What do high confidence, low confidence and no confidence mean in explain plan?
Backup Script was blocked you are unable to archive the data now. how do you analyze it and where do you identify ?
What is the maximum number of dml can be coded in a multiload script?
Which is more efficient group by or distinct to find duplicates?
What is the difference between union and union all in teradata?
What is spool space? Why do you get spool space errors? How do trouble-shoot them?
What are the design features involved in teradata?
Steps to create a data model?
Explain Teradata performance tuning and optimization?