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
- 8 Answers
- 9123 Views
- Satyam, I also Faced
- E-Mail Answers
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
What are the newly developed features of Teradata?
What is the primary index in teradata?
what are the day to day activities of teradata DBA ?
Can any one explain me the difference between BTEQ and MLOAD,TUMP. All canbe used for same purpose but still differnt methods. why ?
Different phases of multiload?
What are normalization, first normal form, second normal form and third normal form?
What type of indexing mechanism do we need to use for a typical data warehouse?
What are the joins in teradata and how many types of joins are there in teradata?
Give the sizes of SMALLINT, BYTEINT and INTEGER.
Can you connect multiload from ab initio?
Difference between star and snowflake schemas?
What is dimensional modeling?
Explain BYNET.
What is a node in teradata?
Explain PDE.
