Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 11218 Views
- Satyam, I also Faced
- E-Mail Answers
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 spool space? Why do you get spool space errors?
What is inner join and outer join?
Why managing the data is important?
What are normalization, first normal form, second normal form and third normal form?
What is the opening step in basic teradata query script?
What are different table types used in teradata?
Why are oltp database designs not generally a good idea for a data warehouse?
What do you mean by caching in teradata?
Which is faster fastload or multiload?
What is the multi-insert?
What is teradata?
What do you mean by teradata intelliflex?
What is the use of having index on table?
What is spool space? Why do you get spool space errors? How do trouble-shoot them?
If the PMON is not working then how do you manage and monitor all processes, resources and sessions etc.
