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
Thanks raju......
But i want in a simple manner..
if there is any other way plz let mi know
thanks in advance
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
Define views in teradata with general syntax.
Explain BYNET.
what are the uses of fact table and dimension table in banking project?
If the PMON is not working then how do you identify and monitor all the processes, resources and sessions ?
How is the teradata different from oracle?
What is the difference between fastload and multiload?
What is the purpose of indexes?
What are the functions performed by bynet?
In general, how do you optimze any sql in teradata?
What is teradata and why it is used?
What are the different methods ot loading a dimension table? A fact table etc?
what is sysdba and sysdbc ? which has high priority ?
how many modules are there in telecome domain?how to explain the architecture?
How to run a query in teradata?
What is the purpose of joins in teradata?