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
Mention a few of the ETL tools that come under Teradata.
When tpump is used instead of multiload?
List out some of the primary characteristics of teradata.
What are the advantages of teradata?
How would you load a very large file in teradata in general? What utility would you use for it? Why?
What is the command in bteq to check for session settings ?
Why managing the data is important?
What is teradata and why it is used?
Describe primary index in teradata?
Explain the term 'row' related to relational database management system?
Where is teradata rdbms used?
How to run a query in teradata?
What do you mean by teradata intellicloud?
How to write the query . eid enm doj dob i want to display the names who worked more than 25 years .
How will you solve the problem that occurs during update?