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 / rkraju
i hope in that above query satisfy ur requirement.for that
question can anyone find new query post me
ravikiran.mca.vadali@gmail.com
Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What is inner join and outer join?
In the Primary Index, what is the score of AMPs that are actively involved?
How do you create tables? Exact syntax, and create profiles, users in teradata?
How to identify ppi columns?
What are the different table types that are supported by teradata?
While creating table my dba has fallback or no fallback in his ddl. What is that?
A certain load is being imposed on the table and that too, every hour. The traffic in the morning is relatively low, and that of the night is very high. As per this situation, which is the most advisable utility and how is that utility supposed to be loaded?
In Teradata, how do we Generate Sequence?
What are default access rights in teradata?
Difference between multiload and tpump?
how do you manage the production space. what are the proactive methods you can take ?
Describe primary index in teradata. And what are the available primary index types?
In general, how do you optimze any sql in teradata?
What are the advantages of teradata?
Define views in teradata with general syntax.