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
Explain teradata architecture?
What is spool space and when running a job if it reaches the maximum spool space how you solve the problem?
List out all forms of LOCKS that are available in Teradata.
What are default access rights in teradata? What explicit right can be given to a user?
If the PMON is not working then how do you manage and monitor all processes, resources and sessions etc.
How to select first n records in teradata?
Hi, If anyone has TD 14 Basics dumps or study materials, please share. nirmaaal1991@gmail.com
How teradata makes sure that there are no duplicate rows being inserted when its a set table?
Highlight a few of the advantages that ETL tools have over Teradata.
What are the various indexes in teradata? Why are they preferred?
What is the purpose of upsert command?
What is inner join and outer join?
What is called partitioned primary index (ppi)?
What is the primary index in teradata?
What tools would you use for that?