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
- 10969 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
Hi, If anyone has TD 14 Basics dumps or study materials, please share. nirmaaal1991@gmail.com
Can you connect multiload from ab initio?
Highlight the need for Performance Tuning.
Explain the types of join supports by teradata?
Highlight the differences between Primary Key and Primary Index.
What is meant by a Clique?
Is multi insert ansi standard?
What are the various indexes in teradata? Why are they preferred?
What is meant by Teradata Gateway?
What is teradata and why it is used?
Difference between inner join and outer join?
What is inner join and outer join?
List the logical and conditional operators that are used with teradata along with their meanings?
What is upsert statement in teradata?
What are the functions involved in shared information architecture?
