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
- 11232 Views
- Satyam, I also Faced
- E-Mail Answers
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
Explain PDE.
List the logical and conditional operators that are used with teradata along with their meanings?
What do you mean by tpt in teradata?
What are the different design perspectives used in teradata?
What is the meaning of Caching in Teradata?
Why are oltp database designs not generally a good idea for a data warehouse?
What is the difference between fastload and multiload? Which one is faster?
What is spool space? Why do you get spool space errors?
If the PMON is not working then how do you identify and monitor all the processes, resources and sessions ?
How can bottlenecks be identified?
What is oltp?
What are the different functions included in the server software?
What is node? How many nodes and amps used in your previous project?
Explain some differences between mpp and smp?
How many tables can you join in v2r5?
