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
Give the sizes of SMALLINT, BYTEINT and INTEGER.
What is spool space?
What are the string manipulation operators and functions associated with teradata?
What do you mean by teradata intellicloud?
List out all forms of LOCKS that are available in Teradata.
What is meant by a Virtual Disk?
What is dimensional modeling?
Explain the most common data types used in teradata?
Why do you get spool space errors? How do trouble-shoot them?
If I wanted to run a TPump job only once per day - basically working on a file that is produced once per day - how would you set up the parameters for that sort of job ?
What are the advantages of teradata?
In BTEQ, how are the session-mode parameters being set?
what is object level locking ? where do appear this type of locking ?
What is node? How many nodes and amps used in your previous project?
What is the use of virtual processor connectivity in teradata?