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 / guest
Thnks for ur rly.......
But if the table is like this
i have a table like sales....the field are
Prodid Jan(jam month sales)Feb March apr may jun july
1 20 76 50 74 94 93 83
2 30 94 40 94 93 93 02
3 40 90 30 49 94 92 56
4 70 20 30 93 46 35 78
5 23 40 40 39 84 46 57
6 85 30 55 93 46 46 46
7 84 20 65 83 56 57 57
8 10 93 40 93 68 57 36
9 57 30 30 83 67 57 79
10 38 83 40 83 55 68 47
11 35 39 90 94 57 78 47
12 83 89 50 93 79 69 69
Actualy data is up to dec month...
If u know the ans plz let me know
Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
What are the enhanced features in teradata v2r5 and v2r6?
What is the difference between global temporary tables and volatile temporary tables?
Can we have an unconnected lkp to lookup a db2 record against a teradata record? Doesnt seem to work. I could be wrong
How to Extract data from multiple legacy systems?
How is MLOAD Client System restarted after execution?
What are some commonly used bteq scripts?
What are the updated features of teradata?
Explain vproc in teradata?
What is called partitioned primary index (ppi) and discuss the advantages of using it in a query?
How to write the query . eid enm doj dob i want to display the names who worked more than 25 years .
What is meant by Teradata Gateway?
What is meant by a Virtual Disk?
Explain the term 'columns' related to relational database management system?
What is the purpose of upsert command?
What are aggregate tables? How do you design them using teradata?