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
- 11402 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
What are the functions of a teradata dba?
List out some of the primary characteristics of teradata.
Did you write stored procedures in teradata?
Difference between stored procedure and macro?
What is the difference between fastload and multiload?
Explain fallback in teradata?
Hi send me the Teradata dumps to my id rajeshanantha@yahoo.co.in Thanks Rajesh. A
In Teradata, what is the significance of UPSERT command?
What do you mean by parsing?
How to view every column and the columns contained in indexes in teradata?
How do you create tables? Exact syntax, and create profiles, users in teradata?
what are the day to day activities of teradata DBA ?
Explain teradata architecture?
What is upsert statement in teradata?
What is partitioned primary index (ppi)?
