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
In Teradata, how do we Generate Sequence?
What is a node in teradata? Explain
Hi send me the Teradata dumps to my id rajeshanantha@yahoo.co.in Thanks Rajesh. A
How to explain project Architecture and flow in teradata interviews?Can please anyone help on this? Am new to teradata.
Can we have an unconnected lkp to lookup a db2 record against a teradata record? Doesnt seem to work. I could be wrong
What is the maximum number of dml can be coded in a multiload script?
Explain teradata architecture in detail with a diagram.
How to Extract data from multiple legacy systems?
why use references rather than pointers in the public api, particularly for arguments which are modified?
When tpump is used instead of multiload?
Explain the term 'database' related to relational database management system?
Explain the term 'primary key' related to relational database management system?
What is the primary index in teradata?
What are normalization, first normal form, second normal form and third normal form?
Why are oltp database designs not generally a good idea for a data warehouse?