i have a table like sales....the field are
Prodid Jan(jam month sales)Feb March apr may jun july
1 20 76 50 74 94 93 83
2 30 94 40 94 93 93 02
3 40 90 30 49 94 92 56
4 70 20 30 93 46 35 78
5 23 40 40 39 84 46 57
6 85 30 55 93 46 46 46
7 84 20 65 83 56 57 57
8 10 93 40 93 68 57 36
9 57 30 30 83 67 57 79
10 38 83 40 83 55 68 47
11 35 39 90 94 57 78 47
12 83 89 50 93 79 69 69
i wat ti find the max sales of every product which i want to
load into target table
- 6 Answers
- 9312 Views
- Satyam, I also Faced
- E-Mail Answers
Answer Posted / guest
thank for ur rly.
But apart from this ans can we any other way?
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
Explain the term 'foreign key' related to relational database management system?
What are the various reporting tools in the market?
What is primary index and secondary index?
What are the different functions performed in development phase?
What is real time and near real time data warehousing?
What is the syntax for case when statement?
How you will check the version of teradata?
How to eliminate product joins in a teradata sql query?
How can bottlenecks be identified?
Define views in teradata with general syntax.
In a table can we use primary key in one column and in another column both unique and not null constrains.if yes how?
What are the components used in smp and massively parallel processing (mpp) machines?
any one answer me how they can analyzing the project using data ware housing?
How do you see a ddl for an existing table?
A certain load is being imposed on the table and that too, every hour. The traffic in the morning is relatively low, and that of the night is very high. As per this situation, which is the most advisable utility and how is that utility supposed to be loaded?
